If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conversion of the number date format to current_date format

Started by learnflower, 20 Mar 2012 02:12:13 AM

Previous topic - Next topic

learnflower

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 .

learnflower


Gyana

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.