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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date difference

I have two date fields in mm/dd/yyyy hh:mi:ss PM format.......

I want to caluculate the difference in same format........

I am using interval function

 

interval

(StartDate-Enddate, 'dd hh:mi:ss' )

I am getting result as dd hh:mm:ss

But in minutes place I am getting  mi(i).....

How to eliminate i and get exact minutes.......

1 Solution

Accepted Solutions
Not applicable
Author

I got it....I changed Number format to Interval and changed Pattern......Thanks

View solution in original post

1 Reply
Not applicable
Author

I got it....I changed Number format to Interval and changed Pattern......Thanks