Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 10 Oct 2004 @ 11:42:26 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Work Week based on Month
From:   Anomy Anom

<-- Anonymously Posted: Thursday, October 07, 2004 14:57 -->

I need to populate a financial calendar table with work weeks that are based on month. The columns are year, month, startdate and enddate. startdate is the first Saturday after the last Friday of the previous month (which can be in the preceeding year). enddate is the last Friday of the month. The table should look like:

     year month    startdate     enddate
     2004 01       2003-12-27    2004-01-30
     2004 02       2004-01-31    2003-02-27
     2004 03       2004-02-28    2004-03-26
     2004 04       2004-03-27    2004-04-30

and so on.

Is there a way to populate the table in one pass?

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020