How to get first date of the model

weilun.wong

Hi,

Does anyone knows how to get the first date of the model?
*The first date that comes from the time dimension
I want to compare the first date of the model against date input by user.

anand.shekhawat

@weilun.wong 

 

If you are looking at the first date of the month you can directly use START() function to get the same, if the module is time dimensioned.

 

 

If you want to get the first date of the model calendar, set the summary of the above Date line item to 'Min'

 

Now create one more module and write the mentioned formula 

First Date.Date[SELECT: TIME.All Periods]

 

I hope it helps

 

~Anand

 

 

 

weilun.wong

Hi Anand,

Thanks for your solution, it works well.