Can anyone help me find a formula showing the 1st of last month?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Need a formula that shows the 1st of last month. Its basically a checkmark formula that is asking if the date shown is last month. it will always be the 1st day of last month. Here is what i have and its not working. 

[Month]=(FirstDayOfMonth(Today())-(1))


*Month is a Date field where the user will enter the first day of the month

Photo of Daniel

Daniel

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
You were in the right track

Try this

[Month]=FirstDayOfMonth(
FirstDayOfMonth(Today())-Days(1)
)
Photo of Daniel

Daniel

  • 0 Points
Perfect, thank you!!!