Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
7 years ago

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

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?
Formulas and functions
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    7 years ago
    There is a formula for LastDayOfMonth(Date d) that will dynamically adjust to the Month/Leap Year as appropriate
  • AmberPolston's avatar
    AmberPolston
    Qrew Cadet
    7 years ago
    That is exactly what I was looking for.  I couldn't find it anywhere.  Thank you so much for your help.