Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

figures in month

hi 

 

i have a column where is date_of_purchase.

i want to minus that date into today date and want to get months.. means how many months utilize till today date..

like if date_of_purchase is 03-07-2016 ... and today is 11 feb 2021. so means total 54 months is utilized if I count manually.

how I get that?

 

2 Replies
PradeepK
Creator II
Creator II

refer to below expression.. update as required

( num(Year(today())) - num(Year(pdate)) ) * 12 
+ num(Month(today())) 
- num(Month(pdate))

Where <pdate> is your column and Month range (pdate,today]

Monthback Cal.png

 

Hope this helps!