Print Page - Having issue with DATE Prompt

Title: Having issue with DATE Prompt
Post by: kvchow on 03 Mar 2015 07:45:01 AM

Hi
I have a DATE prompt in my report,when i ran the report the date prompt is showing like from date:mar2,2015 and to date mar2,2015

But actually that date column is having the dates like this,01-AUG-2012,05-SEP-2014 like this..

When i ran the report for certain dates the format is not matching and report is displaying blank..

How should i go..i mean how to convert the date column like prompt page showing date..

DB2 and cognos 10.1 environment

Thanks,
kvchow

Title: Re: Having issue with DATE Prompt
Post by: Robl on 04 Mar 2015 03:02:36 AM

Are you sure that the source data is a DATE and not a varchar or string that looks a bit like a date?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 03 Mar 2015 07:45:01 AM