I am trying to give users a grid view with "Last week sales", "Yesterday Sales", "Month till date" sales and "Year till date sales".
Month till date, year till date and yesterday were easy to calculate with datediff.
But wasn't able to figure out, how to give them last business week sales.
So that would be Monday to Friday last week.
Hoping someone can help with this calculation.