Date syntax to show a year ago from current year and day

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I need to adjust this syntx to show a years difference from the current
year and day.
Example; if it is January 1, 2005, (Now) then I need it to show January 1,
2004
Me.StartDate = DateSerial(Year(Date), 1, 1)
 
I need to adjust this syntx to show a years difference from the current
year and day.
Example; if it is January 1, 2005, (Now) then I need it to show January 1,
2004
Click to expand...
Me.StartDate = DateSerial(Year(Date)-1,month(date), day(date))
 
Back
Top