Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
brijesh1991
Partner - Specialist
Partner - Specialist

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!

Brijesh

1 Reply
Anonymous
Not applicable

Hi,

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

use..  fabs(Date1)...

Hope that helps.

Regards,
Aadil