Solved: calculate the number of months between two dates - Qlik Community

Report Inappropriate Content · ‎2011-07-26

Hi everyone,

how to calculate the number of months between two dates ?

Any help would be greatly appreciated. Thank you!

Red

danielrozental · ‎2011-07-26

You can try something basic like floor((date_to - date_from)/30). But maybe that's just too basic.

Report Inappropriate Content · ‎2011-07-26

hi,

you can try this :

SubStringCount(concat(DISTINCT MonthName(OrderDate)&';'),';')

regards,

Valentin

danielrozental · ‎2011-07-26

You can try something basic like floor((date_to - date_from)/30). But maybe that's just too basic.

calculate the number of months between two dates