11 Replies Latest reply: Sep 13, 2017 3:17 AM by Pratik Bhor RSS

    Max Date and Min Date from Date Format

    bhavani b

      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