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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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!

Photo of Mollie

Mollie

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
"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?
Photo of Mollie

Mollie

  • 0 Points
the date 6 months from the date manually entered.. sorry.. Every time I think I've figured these formulas out.. I get lost again
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
no problem

AdjustMonth([my date entry field],6)
Photo of Matt

Matt

  • 80 Points 75 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
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)