I am trying to get a date index nunber into a variable but unsure how..
Basically i have a field [Reporting Week Index] and i am trying to store the current value for this field in a variable.
I want it to be dynamic, so when a date in the field [Reporting Date] is selected, this will then change the variable with the [Reporting Week Index] for the date selected.
Add a Set Variable action to the On Select trigger of [Reporting Date] to set your variable to max([Reporting Week Index]). There should be only one max [Reporting Week Index] for the Reporting Date so you'll get the right Week Index number in the variable.
Add a Set Variable action to the On Select trigger of [Reporting Date] to set your variable to max([Reporting Week Index]). There should be only one max [Reporting Week Index] for the Reporting Date so you'll get the right Week Index number in the variable.
