Current date less 2 months

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

Rick Johnston

Our current function is ... EndDate() >= Date() ... which is used to screen
out any results prior to today's date.
We would like to modify this so that instead of today's date we would use
the date 2 months prior to today's date, so that, for example the EndDate()
on 1/22/07 would be 11/22/06.
Would appreciate help on the format for this.
Thanks in advance!
Rick
 
Rick said:
Our current function is ... EndDate() >= Date() ... which is used to screen
out any results prior to today's date.
We would like to modify this so that instead of today's date we would use
the date 2 months prior to today's date, so that, for example the EndDate()
on 1/22/07 would be 11/22/06.
Click to expand...


Use:

EndDate() >= DateAdd("m", -2, Date())
 
Back
Top