5 Replies Latest reply on Aug 14, 2018 12:48 PM by Raheel Farooq

    Max date but less than or equal to current date

    Raheel Farooq

      Hi All,

      I am trying to create a calculated field on a date field, where I want to pick the max available date but less than or equal to current date?

       

      Sample_Date_field

      2017-08-10

      2017-04-11

      2018-04-25

      2018-01-30

      2018-08-10

      2018-08-11

      2018-08-25

      2018-11-30

       

      If today is 2018-08-14 then it should return 2018-08-11. Thanks