Fixing a date variable

[#1]

Hi I wanted to fix a variable based on the date so if the user selects different dates in other fields it doesn't change.

So wanted something like - vCurrentWave = Max(Date of event) the only trouble is I tried this and it keeps changing when users select fields

Any help really appreciated

[tresesco]

Use set analysis like:

vCurrentWave = Max({1} [Date of event])

[#3]

Thanks for your help I tried it in a text box and it didn't work do I need to set up a set analysis. I must be doing something wrong