If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.