I need to Manipulate Dates

William Carl

New member
Local time
Today, 19:00
Joined
Dec 28, 2001
Messages
5
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 ---
 
NewExp: DateSerial(Year([expdate])+1,Month([Expdate]),Day([Expdate])+7)
 

Users who are viewing this thread

Back
Top Bottom