DATE Default

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Is there a way to set the default date in a field to be
yesterday's date?
 
Rick

If you are talking about setting the field's Default value, so that any new
record added gets that default, yes. Try something like:

=Date()-1

in the Default property.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Property sheet data missing also syntax 0
Excel How to get the number of days an item was opened from the today's date. 14
date question 1
Pivot table macro filter data between yesterday and today (date+time) 0
Date changes but shouldn't 7
Problem using Date() for default value in my Date/Time field 4
Bound Date/Time field to automatically display the current date 2
Date Question 6

Back
Top