4 Replies Latest reply: Jul 10, 2015 1:55 PM by Mark Newman RSS

    Using the MonthEnd function in a script

    Mark Newman

      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

      FROM tblPayments;

       

      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.