Results 1 to 3 of 3

Thread: Getting previous business day data db2

  1. 03-11-2016, 11:46 AM #1
    donalejandro
    donalejandro is offline Registered User
    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.
    Reply With Quote Reply With Quote
  2. 03-12-2016, 08:16 AM #2
    Steve R Jones
    Steve R Jones is offline Administrator
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    79
    I don't write code so bare with me.... Seems like you could specify:

    From shipped where shpdate equals 03/11/2016
    Reply With Quote Reply With Quote
  3. 03-13-2016, 02:52 AM #3
    donalejandro
    donalejandro is offline Registered User
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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