Jump to content

Report for all calls not updated in the last 14 days


Recommended Posts

Hi

I'm trying to pull a report that shows all requests that have not been updated in the last 14 days.

I'm using the following custom query but its returning further back than I want. DATE_SUB(NOW(), INTERVAL 14 DAY)

Anybody else done anything similar, or know what query I should run?

Attached is the screen shot from the report.

Thanks

Chris

 

reporting.png

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...