Matching members with aliases
Hi everyone,
We developed a prototype where months were named as m1, m2, m3, ... m12. Now we have been asked to name months after the usual jan, feb, mar...codes and pass the m1, m2, m3... as aliases to them so jan has the m1 alias, feb is m2,... and so on.
Somewhere into the system dates are being input in the YYYYMMDD format, so we have an account member that takes the part of the date corresponding to the month.
E.g:
StartDate = 20181125 makes StartMonth = 11
StartDate = 20180225 makes StartMonth = 2
And one of our calcs had the following:
@MEMBER(@CONCATENATE("m"