Max date selection

[smilingjohn]

Hi All,
Please find the attachment of the QVW application.
Here i have a multibox which has a load date field ..i want to set the max of laod date for which i have the trigger ..

at first it worked .but when i select different date and change the sheet and come back to the Max sheet it doesnt select the max of load date.

Can please someone help me on this ..I am confused

Thanks

[Marco · Accepted solution]

Change the expression in:

=date(max(ALL [Load Date]),'MM/DD/YYYY')

[sunny_talwar]

You can also use {1} to ignore selection in all fields or {<[Load Date]>} to ignore selection in Load Date field

=Date(Max({1} [Load Date]), 'MM/DD/YYYY')

or

=Date(Max({<[Load Date]>} [Load Date]), 'MM/DD/YYYY')