Set Date Value to previous day of current day

[Roby]

In my attendance register I have my date field set to Now()
But since the attendance is not completed until the following day, I would
like this field to show the previous day from when an entry is being made.

Ex. Attendance entry being made 07-Aug-07, would like the default value to be
06-Aug-07 so this doesn't have to be entered manually. [Date] is the control.

Any suggestions?

Thanks for any help provided!

 

[Jeff Boyce]

You did say "any suggestions?"...<g>

Don't call your field [Date] -- this is a reserved word in Access and will
only confuse both of you.

If you are using the Default Value property to fill in a date, and if you
don't care about what time of date, don't use Now() (that gives date/time)
.... instead, use Date().

If you don't actual want (today's) Date(), you could use something like:

Date()-1

to get yesterday's date.


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Roby]

Thank you very much!!!! For all the info. Simple but very effective.

Thanks again, it worked great.

You did say "any suggestions?"...<g>

Don't call your field [Date] -- this is a reserved word in Access and will
only confuse both of you.

If you are using the Default Value property to fill in a date, and if you
don't care about what time of date, don't use Now() (that gives date/time)
.... instead, use Date().

If you don't actual want (today's) Date(), you could use something like:

Date()-1

to get yesterday's date.


Regards

Jeff Boyce
Microsoft Office/Access MVP

In my attendance register I have my date field set to Now()
But since the attendance is not completed until the following day, I would
like this field to show the previous day from when an entry is being made.

Ex. Attendance entry being made 07-Aug-07, would like the default value to
be
06-Aug-07 so this doesn't have to be entered manually. [Date] is the
control.

Any suggestions?

Thanks for any help provided!