Request for help on report filter date - in the last 9 days

[Berto2002]

Someone will be able to answer this in 5 seconds I am sure.

I need to alter the {{DATE:startofmonth}} criteria to something like "in the last 9 days".

What do I put in the box please? I have no idea what query language to use or how to format that.

Thanks in advance

[Jim]

use something like a custom criteria then do

CURDATE() - INTERVAL 9 DAY;

[Berto2002]

Thank you Jim this worked (without the semicolon)

 

CURDATE() - INTERVAL 9 DAY