Scheduled report uses a condition but constantly runs?

[Jared Wason]

Hello,

I have setup a report that I want to run the 2nd Tuesday of each month. I have setup the condition below to make it run only on the 2nd Tuesday. However for some reason this keeps triggering every day despite when I check in a background script it shows the results as returning false. Does anyone see what I am doing wrong here?

[Jared Wason]

Thanks for this, I tried setting the time instead of utilizing the 'Execute Now'  button and the report is still getting sent. Also I am not seeing my log statements that I added show up. Any idea why that would occur?

[Muhammad Khan]

Refer to below KB Article, this could be the reason.

[Orlando] Introduced script sandboxing in Scheduled Reports. Glide classes such as GlideDate, GlideT... 

Below images are from above article for reference.

[Jared Wason]

Tried the java script Date() class and still no luck. Thanks though!

[Muhammad Khan]

Did you try without encapsulating your script in a function?

[Jared Wason]

Yeah, I have tried that as well.