changing a date based on the time of day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ian - 15 Jun 2007 23:36 GMT

Hi all, I'm working on a database to track when mail comes into an office and
put a date stamp on it so we can track how much of each type of mail is
coming in and worked each day. I'm trying to create a function for this date
stamp where if the entry is put into the database after a certain time of day
(i.e. anytime after 4 pm) then the date applied will be for the following day
as opposed to today. Any help?

Reply to this Message

John W. Vinson - 15 Jun 2007 23:51 GMT

>Hi all, I'm working on a database to track when mail comes into an office and
>put a date stamp on it so we can track how much of each type of mail is
>coming in and worked each day. I'm trying to create a function for this date
>stamp where if the entry is put into the database after a certain time of day
>(i.e. anytime after 4 pm) then the date applied will be for the following day
>as opposed to today. Any help?

You could set the DefaultValue of the form control to

=DateValue(DateAdd("h", 8, Now()))

A more complex function will be needed if you want mail arriving Friday
afternoon at 4:30 to get stamped with the next Monday's date... but it's
certainly doable.

John W. Vinson [MVP]

Reply to this Message