Determining Prior Month Date Formula

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

What is the date formula for determining the last day of a prior month period?

Photo of Steven

Steven

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Hi Steven - This should work:


AdjustMonth(LastDayofMonth([Date]),-1)



Where [Date] can be any date field, or could instead be replaced with: Today()



Let me know if that works for you. =]
Photo of Steven

Steven

  • 0 Points
Thanks so much Eric ...
Did the trick!
Photo of Steven

Steven

  • 0 Points
Eric,
This formula is based on another date field, and worked, however ... what if I wanted the field to auto populate not based on another field, but based on today's date (system date)?

Based on some other esearch I found the following, but alas it's not working:

LastDayOfMonth(AdjustMonth(Today), -1)
AdjustMonth(LastDayOfMonth(Today()),-1)
Photo of Steven

Steven

  • 0 Points
Your terrific!
Thank you again!