Hi,
I have to replace a value prompt by a date prompt. since value prompt uses date data item which is in 'yyyymm' format . but since date prompt is of something like 'Nov 11, 2011' format so while using date prompt for the same date data item which is of '201111' format i am getting error called 'RQP-DEF-0354 The query contains one or more unresolved prompts. QE-DEF-0387 Invalid format for numeric prompt 'P_Entry_Month'. QE-DEF-0387 Invalid format for numeric prompt 'P_TRANSACTION_MONth'. RSV-SRV-0042 '.
Please guide me how can i overcome this.
Hi try this
Create a query calculation new_Date as
cast(extract(year,?Parameter1?),char(4))+cast(extract(month,?Parameter1?),char(2))
then disabled the filter on your date and add this
Your Date column=New_date
only check with the values for the month like its 201105 or 20115 my solution wil work for 20115.
if its 201105 then u have make some extra efforts as
create Year ->cast(extract(year,?Parameter1?),char(4))
create Month as->
If(extract(month,?Parameter1?) >10) then
(cast(extract(month,?Parameter1?),char(4)))
else
('0'+cast(extract(month,?Parameter1?),char(4)))
then create New_Date as [Year]+[Date]
then apply the same filter
Your Date column=New_date
Thanks