Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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