Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expert,
can we get date difference in months in load statements in qlik sense
thanks
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
Suggestion please
Try this
=(Year('15/05/2017')-Year('15/08/2015'))*12+Num(Month('15/05/2017'))-Num(Month('15/08/2015'))
Sir,
thanks..
i need month names
monthnames betweeen two dates
Year('15/05/2017')-Year('15/08/2015'))
nope coming null values