How to find the start of the quarter date from quarter in alteryx

[haya]

Hi Team ,

I have a filed called achievement quarter with value as "20174" how do I generate a field date with value "10/01/2017" from the existing field achievement quarter.

Any help would be much appreciated.

Regards,

Haya

[jdunkerley79 · Accepted solution]

A formula tool with expression like :

SWITCH(MOD([YearQtr],10), NULL(), 1, "01", 2, "04", 3, "07", 4, "10") + 
"/01/" + 
ToString([YearQtr]/10, 0)

should give you what you want.

If you want a real Alteryx date then:

ToString([YearQtr]/10, 0) +
SWITCH(MOD([YearQtr],10), NULL(), 1, "-01", 2, "-04", 3, "-07", 4, "-10") + 
"-01"

 Sample attached

[haya]

Thanksalot :)