Formating a date

[moshood]

I have a column of dates which i would like to use to create another column called Lease start Qrt as seen in in the excel imaged attached. The excel formula is there to see how this has been created in excel.

Can someone create a a formula/expression which takes the dates converts it to quarter - year (Q2-19) in alteryx please. 

thanks 

Mosh

[atcodedog05 · Accepted solution]

Hi @moshood 

Try the below solution out.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-format-to-Quarter/td-p/57291

[moshood]

Thank you