how do I create a formula field that changes a date field to the previous month

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
Try this as a new formula date field.  It will always be 1 month back from the date in your date field.

Adjustmonth([my date field],-1)