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