Challenge #367: Manipulating Dates – End of the Month

[Watermark]

Spoiler

 

[ARussell34]

Cool trick!

[logdog0411]

Spoiler

[Qiu]

Finished.

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

Formula
Date2 = DateTimeParse([Date],"%m/%d/%y")
OneMonthLater = DateTimeAdd([Date2],1,"months")
First Day of Next Month = Left([OneMonthLater], 8) + "01"
Last Day of the Month_DateType = DateTimeAdd([First Day of Next Month], -1, "days")
Last Day of the Month = DateTimeFormat([Last Day of the Month_DateType],"%m/%d/%Y")

[sgaditya18]

My solution. very interesting use of date functions! 

[DataCruncher3]

Small challenges can still be packed with learning opportunities! Here's how I used the DateTime and formula tool to solve this:

Spoiler

[olga_strubbe]

Spoiler

A fun challenge , thank you!  It helped me practice my dates functions.

[DataCruncher2]

Guys, please check out my solution. Really proud of the formula I used :D

[Milanz]

my solution ;-)

Spoiler