Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anonymous1
Contributor III
Contributor III

subtracting dates to retrieve total months

hi, 

i have a [start date] field, and i  need to count the months from the start date until today, so something like today()- [start date] = (how many months?).  can anyone help me ?

Labels (1)
3 Replies
lockematthewp
Creator II
Creator II

=num(month(today())) - num(month([start date]))

Brett_Bleess
Former Employee
Former Employee

Natasha, did either of the posts get you what you needed?  If so, please consider using the Accept as Solution button to mark which one(s) helped.  If you are still working on things, shout back, and if you did something different, you can post that and mark it as the solution so others will know what worked for you...

Regards,
Brettt

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.