How to select items for the last N days?

Hello. How to properly write a where clause, if I wanna extract all the items for, let’s say, the last 7 days? I’ve tried standard sql thing like

update_date > DATEADD(day,-7, NOW())

But it tells me that it’s incorrect.
Thank you.

Ah I get it, looks like you have your own vision on how DATEADD function should work.

This is the working clause:

DATEADD(NOW(), -7, ‘DAY’)

1 Like