Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get no of days days between two timestamp columns

Hi

How to get no of days days between two columns

data is in below format in both columns

1899-12-31 00:00:00:0

thanks

15 Replies
Anonymous
Not applicable
Author

still same issue

PrashantSangle

Hi,

try below

interval(floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')),'D')


or


interval(floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t'),'D')


or


floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t'))


Regards,

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
d_prashanthredd
Creator III
Creator III

Can you provide your sample data or app?

Anonymous
Not applicable
Author

i

used this ceiling syntax and able to see correct data , when i cross check i see correct data. but in overall data it is not coming in sorted form.

how can i get sorted data

d_prashanthredd
Creator III
Creator III

I didn't get what you are looking for.. I mean sorted data ?

You want to sort on what..??

Anonymous
Not applicable
Author

yes sorted data