Displaying the first date of my historical years

Options
thbijkerk
thbijkerk Member, ALL USERS, Partner, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hi All,

I was wondering if there is a syntax that gives me the first date of my historical years, based on the timescale settings. My Fiscal Year (currently) goes from 01-06-2018 to 31-05-2019 and I have 2 past years within my model, i.e. the date I'm looking for right now is 01-06-2016. I would like to have a syntax that gives me this date based on the timescale, because it has to 'move' to the next year once we go into the new Fiscal Year. 

Currently this date is a manual input (see attachment).Additionally, almost al other dates are a function of this 'First Actual Date', so I do not want to have the 'First Actual Date' to be a function of the other dates. 

 

hope this is clear enough and looking forward to answers!

 

Best,

Thomas

Tagged:

Comments

  • thbijkerk
    thbijkerk Member, ALL USERS, Partner, Certified Model Builder Posts: 4 Occasional Contributor

    Great, this helps indeed! 

    Thought there would be an easy solution, but just could not come up with it yet. 

     

    Thanks!

  • thbijkerk
    thbijkerk Member, ALL USERS, Partner, Certified Model Builder Posts: 4 Occasional Contributor
    Nice work-around too. I'm using flags a lot as well in the financial models. Like the flexibility of working with it.

Categories