Max loaddate

[smilingjohn]

Hi Expertise

please find the attachment of the QVW file ..

I have a load date ..and i want to set it to max of load date within the triger of a sheet and also trying to add a action withn the text object .

but this is not working ?

Can someone please help me with this ..

I tired the below conditon it is not working .

=date(max(all LOAD_DATE),'MM/DD/YYYY')

Thanks in Avdnace

[tresB · Accepted solution]

Try like:

=Date(Max({1} LOAD_DATE), 'M/D/YYYY')


Reduce no of Ds and Ms to/by one

[smilingjohn]

Hi MVP, 

Thanks for the reply . 

This is working , will this now work for all the date in future ? 

Thanks 

[tresB]

It should as far as your date format doesn't change. Please close the thread by giving Like/Accepting as correct solution.