last date of next 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
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

last date of next month

Post by Apotluri »

I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always
hello105
Participant
Posts: 9
Joined: Mon Sep 03, 2007 9:53 pm
Location: ShangHai,China

Re: last date of next month

Post by hello105 »

I think you can use a store procedure stage to resolve this

Apotluri wrote:I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

No need to code anything external. The high-level logic to do this is to take the date, add 2 months, then subtract one day. The DateFromDaysSince() function performs addition/subtraction from a date.
Post Reply