Date Format Issue

brijesh1991 — Fri, 06 Dec 2013 12:24:03 GMT

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

Re: Date Format Issue

Anonymous — Fri, 06 Dec 2013 12:59:15 GMT

Hi,

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

use.. fabs(Date1)...

Hope that helps.

Regards,
Aadil