Issues using current_date/{sysdate}

[AR_Cognos_Enthusiast]

Hello everyone,

I have the following problem:

I am using a date filter in a report that uses a parameter from a date prompt:

p_date between [date_from] and [date_to].

This filter runs smoothly and the report is done in  2 minutes.

However, if I use the current_date or {sysdate} function instead of p_date, the report keeps running and does not finish.(There is no error massage either)

Has anyone of you experienced similar problems and can help me out?

Thank you very much in advance and kind regards,
AR

[David_Efr]

Is the SQL code for the query properly generated?

[AR_Cognos_Enthusiast]

Hello,

thanks for the reply.
Yes, it is.