Date Query

S

Steve Schanzer

I wish to run a query that adds 60 days to a date.

ie [Date] +60 Days

ideas please

TIA

Steve
 
M

Marshall Barton

Steve said:
I wish to run a query that adds 60 days to a date.

ie [Date] +60 Days


Actually, [a date field]+ 60 will work, but it relies on the
knowledge of how a date field is encoded. Better to use the
DateAdd function:

DateAdd("d", 60, [a date field])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top