date diff between 2 dates

[Anonymous]

Hi Expert,

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

thanks

[Anonymous]

   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]

Suggestion please

[antoniotiman]

Try this

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

[Anonymous]

Sir,

thanks..

i need month names

[Anonymous]

monthnames betweeen two dates

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

[Anonymous]

nope coming null values