Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Date Fomat to Fiscal Year and Quarter

maxiemens
7 - Meteor

Hi together,

 

do you know how can I get for e.g. this date: 2021-02-01 to this format: FY22/23 - Q4 ('FY' YY/YY+1 - 'Q'Q)

 

I should use the formula tool, but how can I do it?

 

The Fiscal year starts at 1st of october.

 

Thanks in advance,

 

Max 

12 REPLIES 12
DavidP
17 - Castor
17 - Castor

Hi @maxiemens,

 

Have a look if this works

 

DavidP_0-1593775769496.png

 

RobertOdera
13 - Pulsar

Hi, @maxiemens 

 

Sorry, I'm just coming back from the Holiday this week, and I will not likely post much until Friday.

Still, what @DavidP  proposes is a great way to code your Fiscal year breaks and Period names!

 

Kindly try David's approach and accept it as a solution + like, if it works for you.

Else, I will watch out for your additional comments and revert starting this Friday.

 

Cheers!

maxiemens
7 - Meteor

@DavidP thanks that works fine.

 

Big thanks 🙂 

Labels