I have a date column in my orders table and also the today date.but I need to get the yesterday’s order date.how 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