Subtract 1 month from any date given

myukassign · Post by **myukassign** » Wed Jul 30, 2008 12:29 am

Can anyone help me to resolve this issue?

I want to reduce 1 month from anydate given and should give me the new date. This should be done thorugh the transformer.

Can anyone tell me a function and its usage?

ArndW · Post by **ArndW** » Wed Jul 30, 2008 1:23 am

There are various ways to do this using different functions. The answer depends on how you define "subtract one month". What is one month less than "July 31"? The simple method is to use ICONV() and OCONV() to convert a display date into an internal date, then subtract 30 and reconvert to a display date. But this might not satisfy your rules and a more complex method would need to be used.

myukassign · Post by **myukassign** » Wed Jul 30, 2008 2:05 am

Oho that function is working for me....

Thanks for the reply...

myukassign · Post by **myukassign** » Wed Jul 30, 2008 2:30 am

Oho that function is working for me....

Thanks for the reply...

chulett · Post by **chulett** » Wed Jul 30, 2008 6:34 am

ArndW wrote:The simple method is to use ICONV() and OCONV() to convert a display date

Fixed that for ya.

ArndW · Post by **ArndW** » Wed Jul 30, 2008 7:17 am

Fixed what, Craig

(I love revisionist history)

chulett · Post by **chulett** » Wed Jul 30, 2008 7:21 am

Dang, where's a WABAC machine when you need one?