How To Fixed My Date Variable

[hamdaniahmad]

Hi All,

Need advice from expert,

I’m searching value max date last month value using this:

=AddMonths(max({<DESC= {'STU'}>}Date_Fix),-1)

I put this into variable vMaxLMonth,

Now when is start making my selections, this value, obviously, changes and I like to make it stick with my original calculation prior my selection.

I’m not calculating this in the load script.

Thanks

[Gysbert_Wassenaar · Accepted solution]

If you change it to this then it will ignore all selections:

=AddMonths(max({1<DESC= {'STU'}>}Date_Fix),-1)

[hamdaniahmad]

Thank you Gysbert.

It is work..!!