Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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