1 Reply Latest reply: Dec 6, 2013 7:59 AM by Aadil M RSS

    Date Format Issue

    BRIJESH GADHESARIYA

      Hi All,

       

      I had a table:

       

      ID,  Date1,  Date2

      1, 22/10/2013,  15/09/2013

      2, 15/12/2013, 17/10/2012

       

      I want to take difference between Date1 And Date2.

       

      Because of Date format of Date1 and Date2 is mixed with Date format and text format.

       

      So I am not getting difference between them.

       

      Is there anyway to convert the text format into Date format, so that I can take the difference between both dates?

       

      All your suggestions will be welcomed!

       

      Brijesh