Fetching Start Month and End Month for a given Quarter

SudhirY
Contributor

Fetching Start Month and End Month for a given Quarter

Hi all,

 

I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for end month Mar 20). 

 

Tried below but didn't work

 

SudhirY_0-1614146830864.png

 

 

regards

Sudhir

2 REPLIES 2
jasonblinn
Master Anaplanner/Community Boss

Re: Fetching Start Month and End Month for a given Quarter

Hi @SudhirY 

 

Try using Period(START(Base Period))

 

The START Will give the first date in a given period, or in this case the base period. Then the Period converts that date to a period. So if you select Q1FY17. The first day is 1/1/17, and the period that falls into is Jan 17.

 

jasonblinn_0-1614147826157.png

jasonblinn_1-1614147839844.png

Let me know if this doesn't work.


Jason

 

SudhirY
Contributor

Re: Fetching Start Month and End Month for a given Quarter

Thanks, Jason, amazing and simple! you made my day!