CODEWITHSUNDEEP
cognos
Zelda
Zelda

Reputation: 2124

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

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?

Upvotes: 3

Views: 56891

Answers (3)

Gabrielgp
Gabrielgp

Reputation: 1

You can use something like this with your query:

SELECT FIELD1 FROM TABLE WHERE FIELD2 = current_date

Asumming that FIELD2 has a date format

Upvotes: 0

Johnsonium
Johnsonium

Reputation: 2005

The best way is to use current_date. This method is data source agnostic and will be converted to the appropriate data source equivalent at run-time.

Upvotes: 1

Zelda
Zelda

Reputation: 2124

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.

Upvotes: 3

Related Questions