June 27, 200619 yr 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.
June 27, 200619 yr Author Answered my own question. Simply add the first field to the second (using get as date function).
June 27, 200619 yr Actually, if a is a date, and b is number of weeks, the calculation should be: a + 7 * b
Create an account or sign in to comment