Test if a specific month is selected then do something

Options
ankiutel
ankiutel Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

Hello,

 

I have a module,and within it I use Time as a Page selector in it. 

My time is formatted like this : Calendar Type : Calendar Months/Quarters/Years, Fiscal Year Start Month: Jan, Current FY : 1 Jan 2018 - 31 Dec 2018. 

 

For a specific line item in my module I want to test something like this : IF Jun is selected THEN do a 1st instruction ELSE IF Dec is selected then do a 2nd instruction ELSE BLANK .

 

My problem is that I don't know how to test if Jun or Dec is selected from pages, instead of other months. 

 

I tried something like this : 

  • IF MONTH(TIME.'Jun 18') THEN 
  • IF ITEM(Time) = Time.Jun THEN 

None of them worked. Please help me!

 

Thank you & best regards

Tagged:

Comments

  • ankiutel
    ankiutel Member, ALL USERS Posts: 2 New Contributor

    Thank you, @DavidSmith, for me it didn't work this, instead I think I found another idea, but it is still in testing.

     

    Have a nice day, 

    Ankiutel

  • geet.patel
    geet.patel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Ankiutel,

     

    if your idea tested and worked, please share it here. As I am also looking for this kind of solution.

     

    Thanks,

    Geet.

  • RHerz
    RHerz Member, ALL USERS, Master Anaplanner - Employee, Employee, Certified Model Builder Posts: 4 Occasional Contributor

    Hello,

     

    Try:

    IF MONTH(START()) = 7 THEN 1 ELSE IF MONTH(START()) = 12 THEN 2 ELSE 0 

     

    Rick

Categories