 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Subtraction dates
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 On Jun 29, 4:10 pm, Jose Ruben Gonzalez-Baird <JoseRubenGonzalezBa...@discussions.microsoft.com> wrote: > Can anyone tell me how to subtract one day from a quarterly submittal date > that exists in a table? [quoted text clipped - 8 lines] > > Thanks in advance. Ruben look up DateAdd in the help file... DateAdd(interval, number, date) eg DateAdd("d",-1,StartDate) Jose, Create a calculated field in your query with... SubmitDateMinusOne : DateAdd("d", -1, SubmittalDate)  Signaturehth Al Campagna Access MVP 2007 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love, and you'll never work a day in your life." > Can anyone tell me how to subtract one day from a quarterly submittal date > that exists in a table? [quoted text clipped - 8 lines] > > Thanks in advance. Ruben THANKS! > Jose, > Create a calculated field in your query with... [quoted text clipped - 12 lines] > > > > Thanks in advance. Ruben |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.