End of Month Formula

I am using this formula to look at the created date of a submittal and then generate the end of the month date based on when it was created:

=DATE(YEAR(Created@row ), MONTH(Created@row ) + 1, 1) - 1

But if something is created on the last day of the month, it puts the end of the month date for the next month. So, for example, if it was created 03/31/2025, then it puts the end of the month at 04/30/2025, but I actually want it to be the 03/31/2025. Is there a way to correct this formula?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

This may not necessarily be an issue with your formula directly but a time zone issue instead.

Try submitting a test each hour and see if there is a pattern where earlier in the day is the correct date and later in the day is actually the next month.

If that is the case, we have a couple of options for working with this to get your desired date.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.