Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need one help on DateFormat

sahasanb
7 - Meteor

I need help in below date format
Period  Start   Period End 

01-Jan- 2021  31-Mar-2021  then period will be 1Q2021 i.e 1st quarter

05-Apr-2022   30-June-2021 then period will be 2Q2021 i.e 2nd quarter

4 REPLIES 4
IraWatt
17 - Castor
17 - Castor

Hey @sahasanb,

Here's one way to do this with the formula tool:

IraWatt_0-1656585377237.png

Any questions or issues please ask :)
HTH!
Ira

 

sahasanb
7 - Meteor

Thanks its working

IraWatt
17 - Castor
17 - Castor

No worries @sahasanb, if you encounter any issues please say 😄 also if you can give a green tick on the answer if your happy with it. 

binuacs
21 - Polaris

@sahasanb Another way of doing this

binuacs_0-1661205139319.png

 

Labels
Top Solution Authors