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: 
Not applicable

Months and Dates

help

how to calculate months between two dates ?

1 Reply
prieper
Master II
Master II

What is a month? What do you need to see, if building the difference betw Nov 30th and Dec 1st: 1 or 0 (or precise 0.03)?

(Date2 - Date1)/30

Month(Date2) - Month(Date1)

might be possible solutions

Peter