-
Getting previous business day data db2
Hello,
I am using db2 my query (very simple) goes as follows:
Select ShpDate, ShpAmt
From Shipped
Here is where I am having an issue. I need to get the previous business day data. For example If today is Tuesday then I need to get Monday data. The problem I encountered is what about Friday night. Our business days are from Monday - Friday. When Monday comes around I need Friday's data. Any help will be apprecieated. Thank you in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|