2 Replies Latest reply on Jan 9, 2019 2:04 PM by Alan Perez

    How to do datediff in days between two date that are formatted as string?

    Tony Fahd

      Hi, I have two dates, Date 1 and Date 2. both formatted as string: YYYY-MM-DD


      Date 1= 2018-04-24

      Date 2 =2018-04-27


      I want to calculate the number of days between both dates.


      I converted both fields into Date and did:  Date1-Date2       but the number of days is not calculated correctly



      any help is appreciated