Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wonder if someone can help me.
I have two user input fields variable in the app. Year and Month. When user has entered this, the value is stored in variable of vYear and vMonth.
Then i want to take this "vYear" and "vMonth" and convert into year and month and Store value in a variable.
vMaxMonthYearName = MonthName(MakeDate($(vYear),$(vMonth)))
Then in the script I am calling the value of this variable by saying
LET vMonthYear = '$(vMaxMonthYearName)';
unfortunately this doesnt work. when i debug, i can see my vMonthYear returns me = MonthName(MakeDate($(vYear),$(vMonth))) but i am expecting it to return the MonthYear value that the user has entered.
Can someone help out?
THanks
make sure
that in your vMaxMonthYearName variable
the formula start with '=' sign
YEs that has =, so its
=MonthName(MakeDate($(vYear),$(vMonth)))