Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

date diff between 2 dates

Hi Expert,

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

thanks

6 Replies
Anonymous
Not applicable
Author

   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
Not applicable
Author

Suggestion please

antoniotiman
Master III
Master III

Try this

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

Anonymous
Not applicable
Author

Sir,

thanks..

i need month names

Anonymous
Not applicable
Author

monthnames betweeen two dates

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

Anonymous
Not applicable
Author

nope coming null values