Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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!