The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Aug 24, 2022 03:03 PM
I was tring to modify a formula DATEADD({Start Date},13,‘days’) to find the end of the month but since months have differing amounts of days I wasn’t sure how I could do that. Bascially, I want the formula look at the start date and then output the last date in that month. So a start of 9/1/22 would equal 9/31/22, etc. Thanks in advance!
Solved! Go to Solution.
Aug 24, 2022 11:44 PM
Hey @Erik_Peterson, this should do what you’re looking for I think:
DATEADD(
DATEADD(
DATETIME_PARSE(
DATETIME_FORMAT(
Date,
"01 MM YYYY"
),
"DD MM YYYY"
),
1,
'months'
),
-1,
'days'
)
Aug 24, 2022 11:44 PM
Hey @Erik_Peterson, this should do what you’re looking for I think:
DATEADD(
DATEADD(
DATETIME_PARSE(
DATETIME_FORMAT(
Date,
"01 MM YYYY"
),
"DD MM YYYY"
),
1,
'months'
),
-1,
'days'
)
Aug 25, 2022 02:40 AM
One key thing to note here is to leave GMT turned on in the formatting preferences for the formula field.
Aug 25, 2022 08:11 AM
ok this awesome, but I’ve got something incorrect b/c I’m getting an error. I do see you were using a euro format date and I’m using a US based date format. Even when I swap the DD & MM in the formula it doesn’t seem to work. See attached screenshot.
Aug 25, 2022 08:48 AM
“Start of Period” is a field name, so it needs to be in {curly brackets}.
That piece of information was missing from @Adam_TheTimeSavingCo’s formula above.
Aug 25, 2022 09:07 AM
oh duh! Thanks so much!