Welcome & Introductions

Get to know the people behind the avatar! Introduce yourself, welcome peers, build connections & extend your network.

Take a moment to introduce yourself to the Community. We'd love to get to know you!

Learn More

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

3 REPLIES 3
IraWatt
16 - Nebula

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
16 - Nebula

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. 

Labels