Fixing Variable in Script

[george55]

Hi all,

Couldn't find a solution to fix a Variable in load editor. Tried with let, set, put it in bracked, even formated in text, but the variable in the app would not stay static. The output is a date, not a dimension. 

Set vP = Date(Floor(RangeMax(Date(Max(Field1)), Date(Max(Field2)))));

Any idea?

Thanks.

[Anil_Babu_Samineni]

Try this

LET vP = '=Date(Floor(RangeMax(Date(Max(Field1)), Date(Max(Field2)))))';

[Kashyap_R · Accepted solution]

Hi

Try this

Date(Floor(RangeMax((Max({1}Field1)),(Max({1}Field2)))))

Hope this helps

Thanks

[george55]

Thanks  Anil_Babu_Samineni , but same behaviour, variable is still dynamic

[george55]

Thanks Kashyap, that worked!