I have a variable auto_name = xxx.1, or xxx.2,… xxx.12
Each of the last digit denote the mth. Eg 1=Jan, 2=Feb…
I want to create a new variable for the mth. I did a quick test with the below, but it doesn’t work.
Even when auto_name = xxx.1, Name_Mth = “Sep”. It can’t seem to read the condition
Name_Mth = IF(RIGHT(auto_name,1)=“1”,“Jan”, “Sep”)