Challenge #359: Manipulating Dates

[nSpire]

Spoiler

[lvprasad]

[Watermark]

Spoiler

 

[RWvanLeeuwen]

Designer Desktop

Spoiler

Designer Cloud (classic Trifacta Experience)

Spoiler

[Christina_H]

Nice and easy this week, I work with dates a lot!

[Sebastian_Chaieb2]

One tool solution

Spoiler

[Chia]

Spoiler

[willemb]

Spoiler

[ASTHA1111]

Below is the solution for the above challenge in which I have created a formula for changing the date field in the above specified challenge the formula for which is given below.

IF

tonumber(right([Date],findstring([Date],"/"))) < 4 then "Q1 "

elseif

tonumber(right([Date],findstring([Date],"/"))) < 7 then "Q2 "

elseif

tonumber(right([Date],findstring([Date],"/"))) < 10 then "Q3 "

else "Q4 "

endif

[garvit96]

Solution