Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016