DSXchange

Hi all,

I am looking for a way to calcuate the week of the month For example, 4/01/06 would calulate to week 1, while 4/8/06 would calculate to week 2.

Is there a function in DataStage to do this?

Thanks

You will need to code a custom routine to perform this task. Keep in mind the scenario what if the 1st April 2006 is a friday, will you still consider it as the first week or no?

I think since I am loading an Oracle table, that I can just use the to_char function to do it.

Thanks

Curious to learn how TO_CHAR could return a week number. What are the business rules that define "week 1 in a month"? (For example read post from dsguru2b.)