Custom date range in Change list report - this Friday to next Friday relative to today?

[kkilroy]

I would like to create a list report of Changes as a gauge on a homepage. Our change week is Friday @ 20:00 through the following Friday @ 19:59 US Eastern. I'd like to be able to create a report with a range relative to today to show upcoming changes for the current change week and another report for changes in the next change week.

This is how I'd determine the start and end (same equation + 7) in Excel:

=(6-WEEKDAY(TODAY())+TODAY())

Day of week you want (Sun=1...Sat=7) minus whatever day of week today is then add that many days to today's date. I do similar to determine what last Friday was (same equation - 7).

but I'm not sure how or if I can do this in servicenow.

Thanks in advance for assistance.

Kevin

[Jamie_douglas]

Hey Kevin,

Sounds like this could be simpler than I first thought..

So you want all changes that are planned this week and next week.

Create a new report

Table - change request

type - calendar

Filters:

planned start date on "this week"

or

planned start date on "next week"

Try this out, if it doesnt work I will try another way but I am sure this should do it.

Let me know your results?

Thanks

Jamie

[kkilroy]

Not exactly what I'm trying to do. You're correct that I want to bound the timeframe using planned start date, however just doing the filters using this week or next week will leave out days in my "change week".

For example, today is Tuesday, 10/14. Therefore, relative to today, the change week that I'm in (This Week) began Friday, 10/10 @ 20:00 and ends this Friday, 10/17 19:59. The next change week (Next Week) begins Friday 10/17 and ends Friday 10/24.

What I'm trying to do is figure out "this week" I could display it and then using +7 or -7 from "this week" I could figure out "last week" or "next week".

Does that add clarity to my question?

[nm13]

Hi kkilroy,

I am facing the same requirement. Could you please share the implementation that you got for the same, if it worked for you.

Thanks!

[gcollins]

Did you ever figure this out? I'm trying to do a change report that runs from Thursday (CAB Meeting) until the next Thursday. Same problem, if I do this week and next week, I get days that will not be accurate. Last week we had a change for the next Thursday that should have shown up in the next weeks meeting, but it showed up in that weeks, which was a problem. I really need planned changes from Thursday and for the next 6 days. Hope I can find an answer, this one has me stuck.