Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

date increment?

tonybar2tonybar2 Member Posts: 72
I am making a database, and i need the date to increment by 72 hours.
Basically there are going to be 2 dates: Date Due = Date Checked + 72hours, how do i program this in my database, and how do i make it where the database will tab and go to next record or is this just default

Thanks for any help
newbee

Comments

  • dokken2dokken2 Member Posts: 532
    : I am making a database, and i need the date to increment by 72 hours.
    : Basically there are going to be 2 dates: Date Due = Date Checked + 72hours, how do i program this in my database, and how do i make it where the database will tab and go to next record or is this just default
    :
    : Thanks for any help
    : newbee
    :

    Since dates are stored in access as a serial number, all you need is to add an integer to the date.

    ex: DateDue = DateChecked + 3
    will increment date checked by 3 days [72 hrs]
Sign In or Register to comment.