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

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

Post by Dave Ellio » Thu, 06 Jan 2005 05:08:41



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)
 
 
 

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

Post by Andi Maye » Thu, 06 Jan 2005 05:26:27

On Tue, 04 Jan 2005 20:08:41 GMT, "Dave Elliott"


Me.StartDate = DateSerial(Year(Date)-1,month(date), day(date))

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW