Report for all calls not updated in the last 14 days

[chriscorcoran]

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

 

[Kelvin]

@chriscorcoranI have used the following on various widgets

DATE(NOW() - INTERVAL 14 DAY)

[chriscorcoran]

Thanks Kelvin