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

Question

I have a task that is being created on a schedule via an automation.&nbsp; This is being ran on the first day of each month.&nbsp; I have a due date field that needs to show the last day of the month.&nbsp; Is there a way to do this that takes into account 31 day months &amp; February?

chayceduncan2 · Answer

There is a formula for&nbsp;LastDayOfMonth(Date d) that will dynamically adjust to the Month/Leap Year as appropriate

amberpolston · Answer

That is exactly what I was looking for.&nbsp; I couldn't find it anywhere.&nbsp; Thank you so much for your help.

Forum Discussion

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

2 Replies

Related Content

Auto-Populate Fields if Blank

Field completed auto populates other fields

Auto-populating from one table to other tables

Disable auto-populate in a field

I Need One Field To Auto Populate

Recent Discussions

Calendar Reports not Loading

Pipelines and Filters

"Button" Data Refresh Quirk

Year Formula help

Passing fields from Child to Parent