Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Date difference

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

1 Reply
Not applicable

Re: Date difference

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

Community Browser