Challenge #359: Manipulating Dates

[matyohan]

Hello, 

Please find here my solution

Spoiler

[Dagrawal]

Here's my solution

[acarter881]

Here's my solution.

Spoiler

[bwins]

Spoiler

Spoiler

[François_Rs]

Spoiler

[Anmol97]

Here's my solution

[at]

[Towers]

definitely overcomplicated this one looking at some other solutions 😂

EDIT: Went over some solutions I found here and managed to get it down to a couple tools, learned a lot by going back through appreciate the smart people here who could help!

Spoiler

edit:

[myastarling]

Here's my solution

[phottovy]

Went for the inefficient but fun "one-tool" solution:

Spoiler

ToString(DateTimeYear(DateTimeParse([Date], '%m/%d/%y'))) + 
'Q' + 
ToString(CEIL(DateTimeMonth(DateTimeParse([Date], '%m/%d/%y')) / 3))