Skip to main content
Question

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

  • November 12, 2015
  • 0 replies
  • 69 views

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!

This topic has been closed for replies.

"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
  • Author
  • Quickbase Alumni
  • November 12, 2015
the date 6 months from the date manually entered.. sorry.. Every time I think I've figured these formulas out.. I get lost again
no problem

AdjustMonth([my date entry field],6)
  • MattMatt3
  • Quickbase Alumni
  • November 13, 2017
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.
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)
Terms & ConditionsAccessibility statement