Changing auto-date rollover time???

[Guitarcam87]

Is it possible to change that time at which the auto date changes to the next day?

For instance, I have a form with a date box and I am using =Date() to auto populate the field. I need that date to change over at 7am rather than 12am.

Is this possible and if so how???

THANKS!!!!

 

[JHB]

Try,

DateAdd("h", -7, Now())

 

[Guitarcam87]

That worked perfectly however now I am trying to do a query and it will not return anything...

The date is showing up as 2/27/2013 4:54:52 AM which is correct and fine

In the query I need it pull only records for the current date. I try using =Date() for the criteria and I get no returns. THoughts???

 

[JHB]

If the time is store together with the date, the use the DateValue function.

DateValue([Yourfieldname]) = Date()

Else, show how you date and query looks like.

 

[Steve@trop]

I have a similar problem. I have a date/time field on a form that has the default set to "=now()" which puts in the system date and time. I need to change it so that the date changes to the next day any time after 11:00 PM (instead of midnight). This is because our third shift starts their day at 11:00. If they start entering data right away, alot of their work shows up on the wrong (to them anyway) workday date. I'm struggling with the expression builder to get this to work.

Does anybody have a good solution for this?

Thanks,

Steve

 

[namliam]

how about adding 1 hour to the default time?

btw resurrecting a 1 year old thread generaly is a bad idea... Next time open a new thread and link the ones you found as having simular issues....