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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate the age difference between two dates in months

Is there a way to calculate the age difference between two date fields in months which can possible be done in the expression itself

Today()-Datefield which will give the result in months?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

= round((Today() - makedate(2014,1,1))/30)

replace makedate with your field

View solution in original post

3 Replies
Not applicable
Author

maxgro
MVP
MVP

= round((Today() - makedate(2014,1,1))/30)

replace makedate with your field

Not applicable
Author

Thanks