Challenge #359: Manipulating Dates

[NathalieHP]

My solution:

Spoiler

[Luke_C]

Don't have the quarter formula yet but still a 1-tooler:

Spoiler

[ARussell34]

Here is my solution!

[anthonyw]

Challenge Completed!

[lanclot23]

Spoiler

[muradmusleh]

 Challenge #359: Manipulating Dates
I used ParsetoDate to convert String to Date, after that I used Formula with DateTimeFormat

[alacoume]

My solution:

[CammyPhillips]

Spoiler

[olga_strubbe]

Spoiler

[pmyers]

One tool solution

Spoiler

Formula:
IF Left([Date], 2)="1/" || Left([Date], 2)="2/" || Left([Date], 2)="3/" THEN Right([Date], 4) + "Q1"

ELSEIF Left([Date], 2)="4/" || Left([Date], 2)="5/" || Left([Date], 2)="6/" THEN Right([Date], 4) + "Q2"

ELSEIF Left([Date], 2)="7/" || Left([Date], 2)="8/" || Left([Date], 2)="9/" THEN Right([Date], 4) + "Q3"

ELSEIF Left([Date], 2)="10" || Left([Date], 2)="11" || Left([Date], 2)="12" THEN Right([Date], 4) + "Q4"

ELSE "" ENDIF