topic Re: Unknown Function "Month" on Server 2019.3 but works in same version designer in Alteryx Server Discussions

Unknown Function "Month" on Server 2019.3 but works in same version designer

hdkarki — Mon, 29 Jun 2020 14:52:37 GMT

Hello,

we are getting Parse Error at char(3):Unknown function "MONTH" (Expression #2) in Alteryx Server 2019.3 but it works on Deigner version 2019.3.

Re: Unknown Function "Month" on Server 2019.3 but works in same version designer

mbarone — Mon, 29 Jun 2020 15:17:32 GMT

I'm not aware of any pre-packaged function called "Month" in Alteryx. Could it be a macro or custom function that was saved? The macro or custom function is probably saved on the local machine but not the server.

Re: Unknown Function "Month" on Server 2019.3 but works in same version designer

patrick_digan — Tue, 30 Jun 2020 12:11:55 GMT

@hdkarki Month is a function included with @jdunkerley79 's Alteryx Abacus formula addins. They would need to be installed on the server. For the Month function in particular, Alteryx now has DateTimeMonth which is a built in function that can replace it.