Does report filters Weekends & holidays ?

[shaik_irfan]

Hello,

I created a report where i need to pull all the tickets which are not updated since last 2 days, for which i use the condition as Active is True & Updated before Yesterday which is working fine but i just wanted to confirm when is a weekend say like today is Sunday will it pull before yesterday means the tickets which are not updated since last Friday or Wednesday ?

I need to set a Scheduled Report where manager should receive the tickets whcih are not updated since last 2 days please help me out how to acheive this

adamstout

[Adam Stout]

I wonder if we could do something for this with some type of SLA that keeps resetting on update.   That would allow us to report on this pretty easy with a related list condition.   Another option would be to write a simple scripted filter that would calculate what was two days ago (using a standard schedule and the GlideSchedule class).

[shaik_irfan]

Adam,

Since we are using Helsinki can you please let help me out with the solution to exclude weekends & holidays

[Adam Stout]

It should work fine in Helsinki.   Do you have a schedule defined as to what the holidays are?   Are they global company holidays or will they differ depending on region?   Excluding weekends should be much easier since you they are always the same, but holidays will require having the holidays configured in the instance.   This may already be done if your SLAs are configured.

[shaik_irfan]

We have SLA's configured and we use general 8-5 weekday excluding holidays schedule