topic Re: date diff between 2 dates in Integration, Extension & APIs

date diff between 2 dates

Anonymous — Tue, 28 Nov 2017 06:45:05 GMT

Hi Expert,

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

thanks

Anonymous — Tue, 28 Nov 2017 06:59:48 GMT

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

Anonymous — Tue, 28 Nov 2017 16:03:24 GMT

Suggestion please

antoniotiman — Tue, 28 Nov 2017 16:56:19 GMT

Try this

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

Anonymous — Tue, 28 Nov 2017 17:01:46 GMT

Sir,

thanks..

i need month names

Anonymous — Tue, 28 Nov 2017 17:36:23 GMT

monthnames betweeen two dates

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

Anonymous — Wed, 29 Nov 2017 03:25:54 GMT

nope coming null values