I can use the MonthEnd function just fine as a calculated dimension, but when I try to use it in a script I get an error that says the function is undefined. Here is the code in the script that is getting the error:
SQL SELECT *,
MonthEnd([Payment Date]) AS PymtMth
The script connects to an Access database in which there is a table called tblPayments containing a field called Payment Date. Any help would be appreciated.