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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Months and Dates

help

how to calculate months between two dates ?

Labels (1)
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