last date in a month

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vsi
Premium Member
Premium Member
Posts: 507
Joined: Wed Mar 15, 2006 1:44 pm

last date in a month

Post by vsi »

If known a month and year. Can we obtain the last date that month, year.
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

You could use

Code: Select all

MONTH.LAST Transform
Search the forum for more details on this transform.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
dsscholar
Premium Member
Premium Member
Posts: 195
Joined: Thu Oct 19, 2006 2:45 pm

Re: last date in a month

Post by dsscholar »

You can use the following transformation to get the date.

Oconv(Month.Last(DSLink3.date),"D DMY[,A,]")

The date supplied is in YYYY-MM format. You can change the format of date for the output.
vsi
Premium Member
Premium Member
Posts: 507
Joined: Wed Mar 15, 2006 1:44 pm

Post by vsi »

Thanks a lot
Post Reply