Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

difference b/w dates

Hi

I have 2 dates date 1=18/3/2015   and date 2 =18/3/2013

Now I want how many months difference between these 2 dates by using qlikview function?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

use year and month functions

Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12

View solution in original post

2 Replies
maxgro
MVP
MVP

use year and month functions

Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12

View solution in original post

sibideepak
Creator II
Creator II