Author Topic: Problem extracting date in cognos  (Read 208 times)

0 Members and 1 Guest are viewing this topic.

Offline rpmolecule

  • Full Member
  • *
  • Posts: 235
  • Karma: +2/-0
  • Seize the Day!
    • View Profile
Problem extracting date in cognos
« on: September 12, 2008, 09:17:40 AM »

i hope someone is nice enough to help me out.

I have a query in the report with a filter like this. I am trying to extract the year out of the approvaldate which is a datevalue with \'yyyy-mm-dd\' format and ?StartYear? and ?EndYear? as parameters but i am getting this error instead.

Code: [Select]
QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position: 13 of: "extract(year"
QE-DEF-0261 QFWP - Parsing text: extract(year,([OCO].[OCO Reports].[ApprovalDate]))

This is what i have in my query filter:

Code: [Select]
extract(year,[OCO].([OCO Reports].[ApprovalDate])) >=?StartYear?
extract(year,([OCO].[OCO Reports].[ApprovalDate])) <= ?EndYear?

Techronnati | where technology never sleeps

Problem extracting date in cognos
« on: September 12, 2008, 09:17:40 AM »

Mountain View


Related Topics

  Subject / Started by Replies Last post
0 Replies
Last post November 27, 2008, 02:09:38 AM
by MrSpecialist
0 Replies
Last post December 12, 2008, 06:03:44 AM
by CyborgRepublic
0 Replies
Last post August 08, 2014, 03:17:18 AM
by rpmolecule
4 Replies
Last post August 25, 2014, 08:23:18 AM
by CyborgRepublic
0 Replies
Last post June 24, 2016, 07:42:59 AM
by Corps

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.