Post Author: NSMactic
CA Forum: Desktop Intelligence Reporting
I am using Bus Odj 6.5.4 and I have a query that has to use a month end posting date e.g. 31/08/2007 that is input via a prompt.
From this prompt I would like the report to display the Month and Year E.g. Month: 8 Year: 2007
I have tried using the UserResponse, DateTo and Month functions but I keep getting an #ERROR message
Is there a way to show this or am I doing something wrong?