Date

[Chad]

Can someone please tell me how to return a date that is 1
year prior to today's date?

Thanks
Chad

 

[Ken Snell]

Check out the DateAdd function:

PrevYearsDate = DateAdd("yyyy", -1, Date())