Working day of last month

tsktsk123 · Post by **tsktsk123** » Mon Feb 18, 2008 9:48 am

Hi,

Can anyone help to understand if there is any function in datastage to get the working day of last month i.e. say the month end is 31-May-2008, then we need to see if the month end day falls on weekend if so we need to get the friday(30-May-2008) and pass it to the target. In this example 31-May-2008 is saturday, so we need to pass the 30-May-2008 to target as it's a friday.

I know we can implement it by using a time dimesion, i like to know if we can implement the same without using the time dimension.

I appreciate any help on this.

regards,
senthil kumar

kcbland · Post by **kcbland** » Mon Feb 18, 2008 10:01 am

Sure, write a function that reads the Time dimension.

chulett · Post by **chulett** » Mon Feb 18, 2008 10:09 am

Dagnabbit, someday someone will listen Ken!

kcbland · Post by **kcbland** » Mon Feb 18, 2008 10:14 am

The simplest, easiest, most scalable and flexible solution seems to be avoided most of the time.

Why not write a function that has an internal array of all days for the last+next 500 years that lists all of the holidays? Another function that lists all of the work days? Another function that correlates all of the days to their last day of the month? Where does it end?

There is NO magic algorithm that gives all answers to all questions, unless folks want to argue about GUT/TOE.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:40 pm

How about using the RMM stage?

rsomiset · Post by **rsomiset** » Thu Feb 21, 2008 7:08 pm

Hi Ray,
What does RMM stage do??

ray.wurlod · Post by **ray.wurlod** » Thu Feb 21, 2008 7:23 pm

Have you searched the forum for it? This post for instance?