Report - Dynamic report that looks at Changes between 2 set days and times

Josh80
Tera Expert

Hello All

I know this is nothing new, but I cannot find anything related to this on the Community.

Using the Condition filter on a list report, I need to have a report that shows all changes between Monday at 17:00 through Thursday at 16:00...but I don't see a way to do that

without some magic scripting.   Am I correct and if so can anyone provide some assistance?   I did see one Community question where a script include was mentioned.


Thank you in advance!

1 ACCEPTED SOLUTION

Try this. If you want to add more filters, you basically just need to add them to all 3 sections. For example, if you wanted this to only show closed changes, you would add an "Active = false" filter to all 3 sections.


Screenshot_4.png


View solution in original post

10 REPLIES 10

Patrick Schult2
Giga Guru

I think this is close to what you want.



This set of conditions would show changes that have a planned start date...


-On a Monday after 5pm


-Any time on Tuesday or Wednesday


-On Thursday before 4pm


CR conditions.png


Hi Patrick



Thanks for the reply - this isn't getting what I need.   It is pulling in old changes as well that occurred between those date ranges.



It needs to be a snapshot of current week, between those days.


Try this. If you want to add more filters, you basically just need to add them to all 3 sections. For example, if you wanted this to only show closed changes, you would add an "Active = false" filter to all 3 sections.


Screenshot_4.png


No dice...entering exactly as shown here.