Scheduled report uses a condition but constantly runs?

Jared Wason
Tera Guru

‎10-18-2022 11:35 AM

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?

 

JaredWason_0-1666117912607.png

JaredWason_1-1666118076831.png

 

 

0 Helpfuls
  • 633 Views
10 REPLIES 10

Jared Wason
Tera Guru
In response to Muhammad Khan

‎10-18-2022 01:24 PM

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?

0 Helpfuls

Muhammad Khan
Mega Sage
Mega Sage
In response to Jared Wason

‎10-18-2022 01:40 PM

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.

MuhammadKhan_0-1666125426837.pngMuhammadKhan_1-1666125452267.png

 

Jared Wason
Tera Guru
In response to Muhammad Khan

‎10-18-2022 01:55 PM

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

0 Helpfuls

Muhammad Khan
Mega Sage
Mega Sage
In response to Jared Wason

‎10-18-2022 02:00 PM

Did you try without encapsulating your script in a function?

0 Helpfuls

Jared Wason
Tera Guru
In response to Muhammad Khan

‎10-18-2022 02:34 PM

Yeah, I have tried that as well.

0 Helpfuls