 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2005What is expression for tomorrow's date
I have an input variable that represents a StartDate. When I try to look at StartDate+1, the query gags. I need to look at data for each of the 4 days following the StartDate. How do I represent this expression? Try and use the DateAdd function DateAdd("d",4,StartDate)  SignatureIn God We Trust - Everything Else We Test > I have an input variable that represents a StartDate. When I try to look at > StartDate+1, the query gags. I need to look at data for each of the 4 days > following the StartDate. How do I represent this expression? Gags? If StartDate is a valid date type, then StartDate + 1 is perfectly valid. Perhaps you want to look at the DateAdd function? It's explained in the Help file... it will add "date" intervals to a date, such as adding a day. SignatureKen Snell <MS ACCESS MVP> >I have an input variable that represents a StartDate. When I try to look >at > StartDate+1, the query gags. I need to look at data for each of the 4 > days > following the StartDate. How do I represent this expression? I would think you would not want to add to the startdate, you would want to pull all the start dates that are equal to today, tomorrow, the next, etc. The criteria under the Start date would be... Date() or Date()+1 or Date()+2 or Date()+3 This would pull any record with a start date of today, tomorrow, etc. If, for some reason, you still need to add days to your "startdate", use the DateAdd function. =DateAdd("d",[StartDate],1) =DateAdd("d",[StartDate],2) etc. SignatureRick B > I have an input variable that represents a StartDate. When I try to look at > StartDate+1, the query gags. I need to look at data for each of the 4 days > following the StartDate. How do I represent this expression? Fixing the data type to date/time corrected the problem. Thanks very much for your help. > I have an input variable that represents a StartDate. When I try to look at > StartDate+1, the query gags. I need to look at data for each of the 4 days > following the StartDate. How do I represent this expression? |
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.