Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
padma277
Contributor
Contributor

date diff

HI Floks,

I am looking for the month difference bewteen today's date and specified date

please find the specific dates below

01/2018

I want get differnce between today's date and 01/2018

how to calculate?

1 Reply
sunny_talwar

May be this

=(Year(Today()) * 12 + Month(Today())) - (Year(MakeDate(2018, 1)) * 12 + Month(MakeDate(2018, 1)))