Date Format Issue

[brijesh1991]

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

[Anonymous]

Hi,

Convert both the date to numbers and then do a subtract.

use..  fabs(Date1)...

Hope that helps.

Regards,
Aadil