If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Trigger - condition is not met

Started by JuliaM, 10 Sep 2015 09:42:07 AM

Previous topic - Next topic

JuliaM

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