Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference Between Two Day's

How can I find out the difference between two days?? Including the holidays.

Example:

(08/01/2011     08/05/2011) = 4 days

Labels (1)
10 Replies
Not applicable
Author

I am trying to subtract two date's and the result was displaying on chart was '-'. The data format are YYYY-MM-DD HH:MI:SS. Please let me know what I am missing hear.

Thanks.