The CreatorCon Call for Content is officially open! Get started here.

How to create report with condition "last 14 days"

mp_unique
Tera Contributor

Hello,

I have created a report with condition "Created on last 7 days". Similarly I would like to create a report with condition "Created on last 14 days" or biweekly. Is that possible as the drop down does not have condition of "last 14 days".

Below is the screenshot for 7 days:

find_real_file.png

1 ACCEPTED SOLUTION

Matthew Smith
Kilo Sage

Hi Mathew

You could use Relative instead of On as your operator and then specify 'on or after 14 days ago'.

Hope it helps.

Matt

View solution in original post

11 REPLIES 11

Matthew Smith
Kilo Sage

Hi Mathew

You could use Relative instead of On as your operator and then specify 'on or after 14 days ago'.

Hope it helps.

Matt

Thanks Matt. That is helpful

Jeff Currier
ServiceNow Employee
ServiceNow Employee

I would use a relative condition like this

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Use relative operator and use relative on or after 14 days ago

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader