Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

padma277
New 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

Re: date diff

May be this

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