Hi all,
i want to derive Week of the Day from Date. Is there any way by which i can acheive this.
Week Of the Year
Moderators: chulett, rschirm, roy
Week Of the Year
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
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
For example, check out:
viewtopic.php?t=84649&highlight=week+year
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.