How can I get the Current Date in a Cognos query expression?

cognos
Ben Brocka picture Ben Brocka · Oct 3, 2012 · Viewed 43.3k times · Source

I have a query expression in Cognos where I need to compare a past date to the current date. I don't see one in the functions list and I'm otherwise unsure how to put the query date inside a query object.

How can I use the current date in a query?

Answer

Ben Brocka picture Ben Brocka · Oct 3, 2012

Depending on your Database software, the object will be either be current_date (SQL Server) or SYSDATE{} (Oracle). If you don't know which you have, just make an expression of just the function and press the Validate button; if you get an error, you used the wrong function for your database.

You can then use this object like any other Date query object, so you can add/compare it to dates in your query or display it somewhere on the page.

Related questions

Cognos report studio group for subtotals

I have this report which is grouped by column cities. when I add a total to the amount field, it doesn't display subtotals for each city... just a grand total at the end. How do I add a subtotal row …

Read More
differences between "Cognos TM1 and "Cognos 10 BI

What the differences between "Cognos TM1" and "Cognos 10 BI"? Which one is consider as BI Tools by IBM?

Read More
IBM Cognos Report Studio: Value prompt default selection from prompt "default text" parameter

I have a value prompt that references the parameter 'Year_Parameter', and a list with one column (a Data Item Expression) that references the same parameter as the value prompt in this way: #prompt('Year_Parameter')# The value prompt has …

Read More