Cognos Query (Urgent!!!!!!!!)

[synchronoss]

Hi Everyone!

I have a query which needs to be implemented immediately. I have a report which has a column called Up and Billable Date. This column contains dates for Up and Billable Orders. Now i need to have a query based on this column that will show report with orders that have become Up and Billable within the last business day.

Can anyone suggest how to do this? This needs to be done on Cognos Upfront

Appreciate ur response!

Thanks
Pradeep

 

[sln007]

Just set your filter to:
((today() - 001 00:00:00.000) = Up and Billable Date) or
(today() = Up and BIllable Date)

The Time interval is from the "value" item in the filter properties select list. That should filter rows to only those that have a "Up and Billable Date" to yesterday or today. And can then be run at any time.

I hope this helps.

 

[synchronoss]

sln007

Thanks! I tried with both filters. The first one throws error as follows

(today() - 001 00:00:00.000) = "Up and Billable Date&quot Syntax error near "0" at line 1.

The second one works fine but i dont see any data in my report as all data gets filtered when i execute my query.

Pls suggest!

Thanks
Pradeep

 

[devul]

You should use now instead of todate since now is a database function.
Secondly If your Up and Billable Date does not have time in it then you should make sure you convert the system date now to date only and then filter out those Up and Billable Dates that equal the current date