Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Convert both the date to numbers and then do a subtract.
use.. fabs(Date1)...
Hope that helps.
Regards,
Aadil