In a code I am trying to study, I got weird problem regarding the date. The date is stored in variable named "L" and it has a value 04/04/2022
When evaluating the date, it returned January not April
Please have a look
Code: Select all
Evaluate("UPPER(TEXT(" & L & ",""[$-409]mmmm\\""))")