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: 
Anonymous
Not applicable

Difference of dates

Hi,

I am attaching the application and suggest me on the same   

1 Solution

Accepted Solutions
Not applicable
Author

Hi John,

Please see attached,

View solution in original post

13 Replies
Not applicable
Author

Please see attached

Anonymous
Not applicable
Author

Hi,

Thanks Charles, this comes out good for this small data.

but I am not getting the accurate result for the large data

could you help me out on the same please. I am sharing the sample app.

Suggestions require from you

Anonymous
Not applicable
Author

Hi,

Thanks Charles, this comes out good for this small data.

but I am not getting the accurate result for the large data

could you help me out on the same please. I am sharing the sample app

Anonymous
Not applicable
Author

Hi,

Suggestions Required

salto
Specialist II
Specialist II

Hi,

added this to the end of the script:

SessionDef:

load *,

  date(left(SessionIn,10),'MM/DD/YYYY') as Race Resident Session;

drop table Session;

rename table SessionDef to Session;

Hope this helps.

Not applicable
Author

Try this one

Anonymous
Not applicable
Author

Hi Charles,

the values are not properly matching..

could you help me out a bit more pls

Not applicable
Author

Hi John,

Can you give me an example of the data that don't match.

thanks!

salto
Specialist II
Specialist II

Hi,

did you try my suggestion?