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!