Date Expression

  • Thread starter Thread starter Mark Lees
  • Start date Start date
M

Mark Lees

I have a date field [currentdate] I want to create a second
date field [6monthsfromnow] that is a 6 months into the
future from [currentdate].

My best quess it to use this expression =DateAdd("m", 6,
"currentdate")

Is this the best aproach?

In addition I would like the [6monthsfromnow] to populate
immediately after the [currentdate] is entered.

Do you enter that in the On Exit event.
 
Are you saying you want to store this in the table? Don't: it's actually a
violation of database normalization rules.

Instead, create a query that has the DateAdd calculation in it as a computed
field, and use that query wherever you would otherwise have used the table.
 
Back
Top