How to find Last sunday of a month

[HemaV]

Hi All,

My requirement says:

my output column should be 1 from Last sunday of March till last sunday of October and other times it will be 0.

How to do this logic in transformer?

Thanks in Advance,

[ray.wurlod]

Calculate the date of the last day of March as

Code: Select all

DateFromComponents(#jpYear#,3,31)

Use a similar technique for the last day of October.

Calculate the last Sunday of March as

Code: Select all

PreviousWeekdayFromDate(svLastDayOfMarch,'Sunday')

Use a similar technique for the last Sunday of October.

[HemaV]

I'm using Datastage 8.1 version and i didnt find the function DateFromComponents().

Thanks,

[ray.wurlod]

Then just use PreviousWeekdayFromDate() with a hard coded (or parameterised) date.

[Kartheek kesarla]

Hi ,

Hope below logic solve your problem

Code: Select all

If column <= NthWeekdayFromDate(2013-04-01, "SUNDAY",-1) and  column >= NthWeekdayFromDate(2013-11-01, "SUNDAY",-1)Then 1 Else  0

Regards
Kartheek Kumar Kesarla