COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: JuliaM on 10 Sep 2015 09:42:07 AM

Title: Trigger - condition is not met
Post by: JuliaM on 10 Sep 2015 09:42:07 AM
Hi everybody!
I have a report that has to run every second Thursday of the month.
This is a condition I used...

_day_of_week (sysdate(), 1) = 4 and (extract(day, sysdate()) between 8 and 14)

Supposed to run today, right? And it didn't!
I even set up a report to run at the same time with this condition and it returned Yes today.

What am I doing wrong?? Help!
Thank you,
Julia