 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Date Add
I have a date field called rqrdate, i have another field called reqdays, I would like to add the together, could someone assist? Thanks, Lee If what you are saying is you want to add the number of days in the field reqdays to the date field rqrdate to create a date in the future then you use the DateAdd function: =DateAdd("d", reqdays, rqrdate)  SignatureDave Hargis, Microsoft Access MVP > I have a date field called rqrdate, i have another field called reqdays, I > would like to add the together, could someone assist? > > Thanks, > > Lee Sir, I want to add the 2 fields together and display a calander date. the rqrdate is the date recieved, the reqdays is total days to complete. So if a rqrdate was 20-July-2008, and the reqdays was 7 it would show 27-July-2008. Thanks! > If what you are saying is you want to add the number of days in the field > reqdays to the date field rqrdate to create a date in the future then you use [quoted text clipped - 8 lines] > > > > Lee What I posted will do exactly that. SignatureDave Hargis, Microsoft Access MVP > Sir, > [quoted text clipped - 16 lines] > > > > > > Lee what about rqrdate + reqdays? I've always used this method to add days. I use other methods to work with months particularly 20th of the month, last day of month, 1st day of month. > I have a date field called rqrdate, i have another field called reqdays, I > would like to add the together, could someone assist? > > Thanks, > > Lee Although that will work, I consider it poor form. I recommend when working with date values to use the intrinsic date functions. SignatureDave Hargis, Microsoft Access MVP > what about rqrdate + reqdays? I've always used this method to add days. I > use other methods to work with months particularly 20th of the month, last [quoted text clipped - 5 lines] > > > > Lee |
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.