How to find the yesterday's order with a date column

I have a date column in my orders table and also the today date.but I need to get the yesterday’s order can I get this?

Probably you can add a math column, take the “now” value minus 1.

Then filter your orders by order time is within the value you calculated above.

1 Like