Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADid it in a round about way before figuring out an quicker solution
would recommend the datetimetrim "lastofmonth" option instead :)
Here's the solution!
Nice new DT function to learn about.
datetimeformat(DateTimeTrim(DateTimeParse([Date],'%m/%d/%Y'),'lastofmonth'),'%m/%d/%Y')
Challenge #367 Done
Not all the expected results are month ends --- for instance, 8-30 is not the end of August...should be 8-31...but other than that, fun challenge.
Tried to do it all in one formula tool
My Solution