Having issue with DATE Prompt

[kvchow]

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

[Robl]

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