View Full Version : I need to Manipulate Dates


William Carl
03-06-2002, 06:01 AM
I have expiration dates for exams which need to be aged a year and 7 days from the expiration date entered into the system.
If anyone could help me --- I'd really appreciate this.

Thanks ---

cpod
03-06-2002, 09:22 AM
NewExp: DateSerial(Year([expdate])+1,Month([Expdate]),Day([Expdate])+7)