I am using SQL and Webi.I have to calculate the Month name from a number field. ie: month_date_closed = 1 in the datab ase, however I want the report to display January.
the below code achieves this however the month_date_closed is a prompt in the report. How do I have the below logic altered to look at the prompt the user entered?
I see a function called UserResponse, but it gives me errors when plugging it in. Any help would be appreciated here.
=Month(ToDate(FormatNumber([Month_Date_Closed];"00") ;"MM")) + UserResponse("Enter Year")
the below code achieves this however the month_date_closed is a prompt in the report. How do I have the below logic altered to look at the prompt the user entered?
I see a function called UserResponse, but it gives me errors when plugging it in. Any help would be appreciated here.
=Month(ToDate(FormatNumber([Month_Date_Closed];"00") ;"MM")) + UserResponse("Enter Year")