C Chad Aug 10, 2003 #1 Can someone please tell me how to return a date that is 1 year prior to today's date? Thanks Chad
K Ken Snell Aug 10, 2003 #2 Check out the DateAdd function: PrevYearsDate = DateAdd("yyyy", -1, Date())