Print Page - Problem with using extract function in report expression

Title: Problem with using extract function in report expression
Post by: fml55555 on 12 Jun 2014 01:57:38 PM

I am trying to make the headers of a list dynamic. The headers involve
Header1: Displaying the previous month and current year (Format eg: Jan YYYY)
Header2: : Displaying the previous month and previous year (Format eg: Jan (YYYY-1))

I am trying to use a report expression current_date and extract function to do the same, however it fails with the error RSV-VAL-0002(CRX-YXX-4010. A parsing error was found). I tried using ASofDate() but result is pretty much the same. I used the following syntax

extract(month,current_date)

Title: Re: Problem with using extract function in report expression
Post by: Francis aka khayman on 12 Jun 2014 08:29:55 PM

extract(month;current_date)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: fml55555 on 12 Jun 2014 01:57:38 PM