how to get the first day of next month

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
yimwai
Participant
Posts: 46
Joined: Thu Jul 01, 2010 9:34 pm

how to get the first day of next month

Post by yimwai »

can we use basic function(such as oconv or ivonv)to get the first day of next month,and use it as a job parameter
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use the logic of the MONTH.LAST Transform to get the final day of the current month, add one to the internal format then, if necessary, convert to external format.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply