Max Date and Min Date from Date Format

[bhavvibudagam]

Hi Everyone,

I have a date field in Number format like original date below.I have converted that number format date to DD-MM-YY Format date like below with below script.

Date(Remedy_Date,'DD-MM-YY') AS Remedy_Date,

In the text box I have taken the max date like  '$(=Max([Remedy_Date]))' then I got the correct date as 09-09-17.

But while taking Min date like '$(=(Max([Remedy_Date])-1))' getting number format and wrong number also.

Please help me on Min date.

Thanks in advance

[Anonymous]

To get maxdate

'$(=Max([Remedy_Date]))'

To get mindate

'$(=(Min([Remedy_Date])))'

To get Second highest date

'$(=(Max([Remedy_Date], 2)))'

Regards

Tahemas Momin

[vinayakg]

Try This,

To get Second Highest Date

=Date(Max(Remedy_Date,2),'MM/DD/YYYY')