Get end of Month based on year and Month

[puliram]

Can any one suggest how to get the last day of a month based on my source data

For Example
I am getting from source 200812(year and Month)

Then my output should be 20081231(end of that month and year)

Say one more example
If I am getting 200802(Year and month)

Then my output should be 20080229(end of month which is leap year)

Any Suggestions please

[abhijain]

viewtopic.php?t=127274&highlight=last+month

Hope this will help

[ArndW]

The logic is to take your year/month, add one month, create a date of the first day of tht month and then subtract a day.

[Sainath.Srinivasan]

and to find next month, take first day of current month and add 31 to it.

[DSguru2B]

Or Just use a Time Dimension table.

[puliram]

Can any one give me the solution for below question using datastage Transformer or any solution using DataStage.

Can any one suggest how to get the last day of a month based on my source data

For Example
I am getting from source 200812(year and Month)

Then my output should be 20081231(end of that month and year)

Say one more example
If I am getting 200802(Year and month)

Then my output should be 20080229(end of month which is leap year)

Any Suggestions please[/quote]

[ArndW]

The solution given in the thread solves your problem as well. Add 1 to the month then subtract a day. That also solves leap year issues.

[priyadarshikunal]

do you want someone to write the complete derivation? you can search for it, or read datastage manual for datefromdayssince() function. you may need to use it twice.

[rohithmuthyala]

Extract the month part alone.
Check if month is 04,06,09,11 then append 30 to the existing string.
Else if month is 02 and (Year%4)=0 then append 29
Else append 31 to the existing string.

The above can be handled using Stage variables in the Transformer stage.

[ray.wurlod]

... except where the year number is divisible by 400.

Further, the recent earthquake in Chile may have changed the earth's rotation slightly - the year may be marginally shorter. Do you need to worry about that?

[ReachKumar]

Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

[puliram]

Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

% dont work in transformer..wat would be the function instead

[chulett]

Mod()

[puliram]

Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

% dont work in transformer..wat would be the function instead and also we are missing fed 28 month ending

[puliram]

Extract the month part alone.
Check if month is 04,06,09,11 then append 30 to the existing string.
Else if month is 02 and (Year%4)=0 then append 29
Else append 31 to the existing string.

we are missing Feb 28 Month ending in this logic and how can we handle % datastage transformer

The above can be handled using Stage variables in the Transformer stage.