Subtraction dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to subtract one day from a quarterly submittal date
that exists in a table?

For instance, my quarterly submittal date is September 1, 2007.

How can i construct my query so that when i subtract one day, my result
becomes August 31, 2007?

Similarly, my result would be November 30, 2007 aftersubtracting one from
the December 1, 2007 submittal date.

Thanks in advance. Ruben
 
Can anyone tell me how to subtract one day from a quarterly submittal date
that exists in a table?

For instance, my quarterly submittal date is September 1, 2007.

How can i construct my query so that when i subtract one day, my result
becomes August 31, 2007?

Similarly, my result would be November 30, 2007 aftersubtracting one from
the December 1, 2007 submittal date.

Thanks in advance. Ruben
Click to expand...

look up DateAdd in the help file...
DateAdd(interval, number, date)

eg
DateAdd("d",-1,StartDate)
 

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

Similar Threads

Use Query or Macro to Creat enew Database 1
Date query, subtract 3 months 10
Lookup with table 1
Dates from Excel not Importing Correctly into Project 1
The DATE debate 0
Month 7
subtract times with a negative result 1
can i upload template formatted emails to a data base or into exce 1

Back
Top