Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: previous business day

    Hi

    A table has the columns first_date and add_date. I need to do a conditional retrieval for those records where

    first_date is less than the (previous business day from the add_date)

    select * from table
    where first_date < ?

    Is there a day function I can use for the previous business day?


    Thanks
    railway123

  2. #2
    Join Date
    Oct 2003
    Posts
    13
    No, there is no built in function to get the business_day. It won't be possible to have such a function because the holidays change from corp to corp, state to state and country to country. However, you can write your own stored procedure to get the business day, we have one.

    HTH

    GP

Posting Permissions

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