Getting previous business day data db2
Results 1 to 3 of 3

Thread: Getting previous business day data db2

  1. #1
    Join Date
    Apr 2013
    Posts
    39

    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.

  2. #2
    Join Date
    Apr 2011
    Location
    Dallas, TX
    Posts
    48
    I don't write code so bare with me.... Seems like you could specify:

    From shipped where shpdate equals 03/11/2016

  3. #3
    Join Date
    Apr 2013
    Posts
    39
    Thantks Steve,

    What I trying to get away from hard coding a date, what I am looking for is in a function. Thanks anyways.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •