Good evening everyone,
I have a field named “Date” in format mm/dd/yy and I need to create a new “Stmt Month” field based on “Date” that gives me the month in Date plus one month, i.e. if Date = 11/07/20 then “Stmt Month” must be December 2020.
I am using the following formula: datepattern(monthmath(date(“Date”),1),“Month YYYY”) but I get the error message date( function: Illegal date “Date” (month must be from 1 to 12).
What is wrong in the formula?
Thanks for your help.