isaaccs Posted June 27, 2006 Posted June 27, 2006 This is very simple, but a few minutes of research haven't yielded the answer. I need to calculate a "follow-up" date. The result should calculate based on two existing fields: a) The initial entry date, entered by the user. The follow-up threshold, entered as the number of weeks. The calculation should then be a+b - I know I need to use get as date and get as number functions, but I'm not quite sure how... Any help most appreciated.
isaaccs Posted June 27, 2006 Author Posted June 27, 2006 Answered my own question. Simply add the first field to the second (using get as date function).
comment Posted June 27, 2006 Posted June 27, 2006 Actually, if a is a date, and b is number of weeks, the calculation should be: a + 7 * b
Recommended Posts
This topic is 6786 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