Challenge #367: Manipulating Dates – End of the Month

[robbinrv]

Did it in a round about way before figuring out an quicker solution

Spoiler

would recommend the datetimetrim "lastofmonth" option instead :)

[gerda]

Spoiler

Here's the solution!

[TurboToad]

Nice new DT function to learn about.

Spoiler

datetimeformat(DateTimeTrim(DateTimeParse([Date],'%m/%d/%Y'),'lastofmonth'),'%m/%d/%Y')

[Arjunmarwaha09]

Challenge #367 Done 

Spoiler

 

[ggruccio]

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.

Spoiler

[Asmaa-jirani]

Spoiler

[CharlotteGuy]

Spoiler

[mmontgomery]

Tried to do it all in one formula tool

Spoiler

[Clifford_Coon]

My Solution

Spoiler

Already had created macro to do this:

 

 

[nSpire]

Spoiler