Deriving the month/quarter value from the line item

Options
praba71
praba71 Member, ALL USERS Posts: 5 Frequent Contributor
in Planning & Modeling

Hi

I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format.

Month: Jan 21

Quarter :FYQ1 FY21

Year:FY21

Is there any formulas to derive these values?

 

Thanks

Prabakaran

 

Tagged:

Comments

Categories