Challenge #367: Manipulating Dates – End of the Month

[TimN]

Here is my solution

[olivier_newman]

my solution to 367

[dkungu]

solution

[krishnakumare]

 

[Rob-Silk]

Solution attached below:

Spoiler

[snbandi]

DateTimeTrim to the rescue

[lyon_abido]

Spoiler

Great challenge!

[tristank]

Always forget about those trim variables

Spoiler

[asultanov]

Spoiler

DateTimeAdd([DateTime_Out], 1, "month")
DateTimeTrim([DateTime_Out], "month")
DateTimeAdd([DateTime_Out], -1, "day")

Spoiler

[kcollazos]

This problem is great for practicing DateTime functions in the formula tool!