Skip to main content
Question

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

  • December 18, 2018
  • 0 replies
  • 77 views
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?
    This topic has been closed for replies.

    There is a formula for LastDayOfMonth(Date d) that will dynamically adjust to the Month/Leap Year as appropriate
    That is exactly what I was looking for.  I couldn't find it anywhere.  Thank you so much for your help.
    Terms & ConditionsAccessibility statement