I have a query that I need to add 3 years to a date when ran. the fiels is called EXAM_DATE the only way I thought I could do this
DateAdd(“d”,1095, "EXAM_DATE")
but I get a data type mismatch?
Last edited by komet12; 09-09-2010 at 01:03 PM.
Solved
just enter in the spot you want the expire date in the query and use the following:
EXPIRE_DATE: [EXAM_DATE]+1095
The 1095 is a 3 year span between dates
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks