3 Replies Latest reply on Feb 3, 2019 12:20 AM by Mahfooj Khan

    If start date=end date then "start date" else "start date to end date" with format of "mm/dd/yyyy"

    cathyo

      If Start Date=End Date then "Start Date" else "Start Date to End Date" with all date formats as mm/dd/yyyy. Right now is shows as "yyyy-mm-dd."

       

      Example of result:

       

      record  dates

      1           2019-04-19

      2           2019-04-01 to 2019-04-20

       

      Example of result wanted:

       

      record  dates

      1           04/19/2019

      2           04/01/2019 to 04/20/2019

       

      Thanks