calculate the number of months between two dates

[#1]

Hi everyone,

how to calculate the number of months between two dates ?

Any help would be greatly appreciated. Thank you!

Red

[#2]

hi,

you can try this :

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

regards,

Valentin

[danielrozental · Accepted solution]

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