I searched around but did not find a solution or something similar to what i'm working with. what im trying to do is whether it would be doable in a query or better off in vba. the dataset i'm working with is a day old, meaning it'll always be yesterday's date and prior. and the work week is a mon-fri
this is a 2 part question, the first question is:
if today is a Monday, how would the coding be to include the weekend into Friday? also Monday holidays like labor day would be treated as a weekend so it'll get included in the Friday total as well. for that I was thinking of having a table strictly as holidays as an exception.
the second question is pulling prior day, would it basically be:
this is a 2 part question, the first question is:
if today is a Monday, how would the coding be to include the weekend into Friday? also Monday holidays like labor day would be treated as a weekend so it'll get included in the Friday total as well. for that I was thinking of having a table strictly as holidays as an exception.
the second question is pulling prior day, would it basically be:
PHP:
where tbl.shipdate=Date()-1