Forum Discussion

MollieMollie's avatar
MollieMollie
Qrew Member
10 years ago

How do I create a formula that autofills the date 6 months from the date entered?

I need to create a formula that will show the date six months from the date entered - I need to be able to track when each employee is due for a review. Thanks in advance!
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
The date that the record was entered into Quick Base is the automated system field called [Date Created].  That is actually a date/time field type with the date and the time.

If you wanted to make a formula date field for that date plus 5 days the formula would be

ToDate([Date Created]) + Days(5)