Dates

[Anonymous]

Hi

I have an trigger when document open where date is selected as max date , but I have few expressions in the chart as below as for the same date column (but checking previous date value) which are not working , can someone please suggest a solution.. the values are shown for clndr_dt for the max value only , do I need to have another column to calculate previous date?

please help

Attached the application

Thanks

[settu_periasamy]

Hi,

You can try to use the below expression in your trigger

=Max({1}Date,2)   => This will always give the 2nd Maximum value, if you want based on selection, just remove {1}

Or, if you want always the 2nd Maximum value, you can use the same expression in your variable too..

Check the Attachment.