 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / December 2005rendered date
Is there some sort of formula that anyone knows of that it if provied it was a date it will tell me was the date was a number of days before it. Ex.. Say i put in a 12/29/2005 as a starting point and I want to know what the date was 90 days ago.... > Is there some sort of formula that anyone knows of that it if provied > it was a date it will tell me was the date was a number of days before > it. > > Ex.. Say i put in a 12/29/2005 as a starting point and I want to know > what the date was 90 days ago.... Yeah. It's called DateAdd. You can even subtract time periods from it. If you want to find time differences between dates, try DateDiff > Is there some sort of formula that anyone knows of that it if provied > it was a date it will tell me was the date was a number of days before > it. > > Ex.. Say i put in a 12/29/2005 as a starting point and I want to know > what the date was 90 days ago.... =DateAdd("d", -90, YourDate)  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
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.