Week Of the Year

anupam · Post by **anupam** » Thu Mar 11, 2004 6:04 am

Hi all,

i want to derive Week of the Day from Date. Is there any way by which i can acheive this.

anupam · Post by **anupam** » Thu Mar 11, 2004 6:05 am

Just correcting the previous message. I want to derive wekk of the Year from the date. How to go abt it.

chulett · Post by **chulett** » Thu Mar 11, 2004 7:57 am

Never hurts to search the forum first! Chances are someone else has already had this question (or at least a very similar one) asked and answered.

For example, check out:

viewtopic.php?t=84649&highlight=week+year

ray.wurlod · Post by **ray.wurlod** » Thu Mar 11, 2004 4:33 pm

Take a look at the WEEK.TAG Transform supplied with DataStage. It's under Built-In\Dates category of the Transforms branch.
In turn it invokes the WeekTag function, which is under the Examples category. In the routine you will find the business rules that determine which week is the first in the year (the week begins on Monday and must have 4 dates within the year.)
You can clone and adapt to suit your own particular requirements.