Date field to auto-populate the last day of the month

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I have a task that is being created on a schedule via an automation.  This is being ran on the first day of each month.  I have a due date field that needs to show the last day of the month.  Is there a way to do this that takes into account 31 day months & February?
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
There is a formula for LastDayOfMonth(Date d) that will dynamically adjust to the Month/Leap Year as appropriate
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
That is exactly what I was looking for.  I couldn't find it anywhere.  Thank you so much for your help.