Discussions

Expand all | Collapse all

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

  • 1.  Date field to auto-populate the last day of the month

    Posted 12-17-2018 22:36
    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?


  • 2.  RE: Date field to auto-populate the last day of the month

    Bronze
    Contributor
    Posted 12-17-2018 22:41
    There is a formula for LastDayOfMonth(Date d) that will dynamically adjust to the Month/Leap Year as appropriate


  • 3.  RE: Date field to auto-populate the last day of the month

    Posted 12-18-2018 14:04
    That is exactly what I was looking for.  I couldn't find it anywhere.  Thank you so much for your help.