Print Page - Conversion of the number date format to current

Title: Conversion of the number date format to current_date format
Post by: learnflower on 20 Mar 2012 02:12:13 AM

Hi ,

I have a date dataitem which is in the following date format 'YYYYMM', I should limit the prompt having use value as the following date to current_date .
So could u plzz guide on the filter expression

Please help me on this .

Title: Re: Conversion of the number date format to current_date format
Post by: learnflower on 21 Mar 2012 01:16:07 AM

Any updates on this :(

Title: Re: Conversion of the number date format to current_date format
Post by: Gyana on 22 Mar 2012 04:19:38 AM

There is no Day. The Query have only Month and Year. So it is not possible to make Current Format.

If you want MM-YYYY then its possible by extracting MM & YYYY.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: learnflower on 20 Mar 2012 02:12:13 AM