Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

date diff between 2 dates

Hi Expert,

can we get date difference in months in load statements in qlik sense

thanks

6 Replies
rupesh632
Contributor

Re: date diff between 2 dates

   if(day(date2)>=day(date1),

num(month(MonthStart(date1)-MonthStart(date1)))-1,

num(month(MonthStart(date2)-MonthStart(date1)))-2) as newdate,

i am getting month numbers...needs month name

rupesh632
Contributor

Re: date diff between 2 dates

Suggestion please

antoniotiman
Honored Contributor III

Re: date diff between 2 dates

Try this

=(Year('15/05/2017')-Year('15/08/2015'))*12+Num(Month('15/05/2017'))-Num(Month('15/08/2015'))

rupesh632
Contributor

Re: date diff between 2 dates

Sir,

thanks..

i need month names

rupesh632
Contributor

Re: date diff between 2 dates

monthnames betweeen two dates

Year('15/05/2017')-Year('15/08/2015'))

rupesh632
Contributor

Re: date diff between 2 dates

nope coming null values

Community Browser