Skipi Posted March 13, 2007 Posted March 13, 2007 Hi, I've a database that stores various calibration certs. What I want to add to it is the next due date, based on the last test date plus the frequency. ie. 1 month, 3 months, 6, 12 etc I've tried a few things but haven't found anything to work yet. Thanks in advance, Skip
mr_vodka Posted March 13, 2007 Posted March 13, 2007 Let ( d=last test date; Date ( Month(d) + frequency; Day (d); Year (d)) )
Recommended Posts
This topic is 6467 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now