Challenge #367: Manipulating Dates – End of the Month

[VipulThakur]

Solved this challenge with below tools:

• Formula 
• Select 

Thanks

[vidyasurendra]

My solution.

[boglarkalipka]

solved

[trepryor]

Used the text input tool to insert a table with the last day of each month and joined it with parsed dates.

 

[synergy825]

Here is my solution:

Spoiler

[caltang]

Done! DateTimeTrim is awesome!

Spoiler

[Tgigs]

My solution.

1. Extract the month + 1 and the year

2. Create a date using year, month + 1, day 1

3. Use datetimeadd to subtract 1 day

Had to watch out for the year when calculating the month + 1. If the month number is 12, then have to also add 1 to year for month + 1.

[RWvanLeeuwen]

1 tool required:

Spoiler

[WaltReed]

Got lazy and did it in 2 steps

[Dani_Lin]

solved