last date of the month

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
swathi Singamareddygari
Participant
Posts: 48
Joined: Fri Feb 29, 2008 1:09 am
Location: Bangalore

last date of the month

Post by swathi Singamareddygari »

Hi,

I want to calculate the last date of the month .
The date i am getting from a sequential file.

data from source:2008-09-05

i want output as 2008-09-30

Can any one please tell me how to implement this in parllel jobs


Thnaks for your help

Regards

Swathi S
Thanks&Regards
S.Swathi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You might get your answer faster if you Search DSXchange. This question has been asked, and answered, previously.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

An Exact search for "month end date" will answer your question.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply