Skip to Content
Former Member
Sep 19, 2007 at 03:03 PM

Month Function from User Response


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?

Many thanks