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
    10 years ago
    "from the "date entered" - did you mean the date that the QuickBase record was entered or 6 months from a date field manually entered on the form?
  • MollieMollie's avatar
    MollieMollie
    Qrew Member
    10 years ago
    the date 6 months from the date manually entered.. sorry.. Every time I think I've figured these formulas out.. I get lost again
  • MattMatt3's avatar
    MattMatt3
    Qrew Member
    8 years ago
    What would the formula be for date record was entered into Quick Base? I'm trying to get a formula that shows the date 5 days after the record was entered into Quick Base. Thanks.
  • 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)