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

    Date Format Issue


      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!