NOWfunction question

[Guest]

Background: I have a db at work where the operators of a machine enter the
Date as one of the fields. Problem somepeople can't remember the correct
date, so when I run a report for that date I get garbage.
Here is my problem: I want to have the date auto populate, which is no
problem; but this db is for 2nd shift, so if the operator enters data after
midnight, the numbers for that assembly run will go on the next day's report.
I thought about having the Date field populate with something like =Now
-Hour(3) so the time would be always be 3 hours earlier, but that doesn't
seem to work.
Is this making sense?
Any suggestions are appreciated.

 

[UpRider]

Ed, 3 hours is 1/8 of a day.
Now - .125
will work fine.

UpRider

 

[Guest]

Thanks, that did work. But now my queries, which filter by [Date?] won't work.

 

[UpRider]

ED, if you're using an expression like
now() - .125
in a query criterium, do it like this:
now() - (.125)

UpRider

Thanks, that did work. But now my queries, which filter by [Date?] won't
work.

Ed, 3 hours is 1/8 of a day.
Now - .125
will work fine.

UpRider

 

[Ken Snell \(MVP\)]

You can use the DateAdd function:

=DateAdd("h", -3, Now())