caluclate end date based on start date and term in months
i need to calculate an end date based on start date and number of months.
I have the field start date and term which is months. i need to calculate an end date based on those fields.
70
10298
d5deccuBWr4yUOacwZ5xHE
1 Reply
dandiebolt
Questions asked: 59
Questions answered: 1760
Points earned: 3676
Questions answered: 1760
Points earned: 3676
Allstar
Advisory council of community power users.
02/07/12 11:06am PST
Latest post
You can't do this becasue a month is a variable duration (28-31 days):
[start date] + Months([term])
but if you redefined your term to be days or weeks you could do this:
[start date] + Days([term])
[start date] + ToWeeks([term])
If you want to stick with a term of months use this:
AdjustMonth( [start date] , [term])
dandiebolt@yahoo.com ~ (734) 985-0721 Google Voice
All Your QuickBase Are Belong To Us Blog: http://quickbase.posterous.com/
All Your QuickBase Are Belong To Us Blog: http://quickbase.posterous.com/
