Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
how to calculate the number of months between two dates ?
Any help would be greatly appreciated. Thank you!
Red
You can try something basic like floor((date_to - date_from)/30). But maybe that's just too basic.
hi,
you can try this :
SubStringCount(concat(DISTINCT MonthName(OrderDate)&';'),';')
regards,
Valentin
You can try something basic like floor((date_to - date_from)/30). But maybe that's just too basic.