Find the difference between months

[#1]

Hi, good day everyone !

I want to get the number of months between 2 months. where

The expression I am using is

Month ([Expiry Date])-$(@calendarMonth) where Month([Expiry Date]) returns result like 'Aug' and $(@calendarMonth) returns result like 'July'.

Is it I need to convert the month string to number ?

Thanks sincerely for your help 🙂

[#2]

Hi all,

Thanks for all of your helps.

I found the way suit to my work and it works.

I need to put this (Match('$(@calendarMonth)', $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))) in the calculation expression and for the variable, just set to @calendarMonth=GetFieldSelections(PeriodMonth) . It is not working by putting the Match expression together with the GetFieldSelections.

Thanks!