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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

calculate number of minutes between two dates

Hello

got in a table 2 fields of type date time

ex:

begin                         end

2014/6/25 3:15:45     2014/6/25 4:33:45

...

I want to calculate the number of minutes between begin and end fields

please advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
shane_spencer
Specialist
Specialist

interval( end - begin, 'mm') as Duration,

View solution in original post

3 Replies
shane_spencer
Specialist
Specialist

interval( end - begin, 'mm') as Duration,

satishkurra
Specialist II
Specialist II

Use IntervalMatch function.

m_woolf
Master II
Master II

(end-begin) * 24 * 60 as minutes;