I'm trying to use the 'Invoke Custom Function' to populate a new column in a query. The function requires a date parameter to be passed and a financial period is returned.
I've imported the function from a SQL Server database and tested it by passing in date from the selection calendar and the function returns the financial period as expected. When I 'Invoke Custom Function' to add a column and pass in the parameter, changing the parameter setting from 'date/time' to 'Column Name' and selecting my date column, the step completes but it returns errors with the following message;
Does anyone have any ideas about getting around this?