Find day of the next month

Jamesvanam · Post by **Jamesvanam** » Mon Sep 13, 2004 11:16 am

Hi,
I'm trying to find the first day of the full month following a date(which is the input value).
not able to find the functions, could somebody please help
Thank you
James

chulett · Post by **chulett** » Mon Sep 13, 2004 12:23 pm

There are a couple of 'Built-In' Transforms you can look at to get some ideas:

MONTH.FIRST
MONTH.LAST

Both use ConvertMonth(), you could either leverage one of these or write something new to do what you need.

Jamesvanam · Post by **Jamesvanam** » Mon Sep 13, 2004 12:46 pm

Thanks Craig.
I'm sorry I forgot to mention I need the first day of the next full month or Quarter following the input date. I guess I'll have to write a new function

james

ray.wurlod · Post by **ray.wurlod** » Mon Sep 13, 2004 3:56 pm

No you don't.
MONTH.LAST(TheDate) gives you the last day of the month in which the date occurs, in internal format.
Therefore, (MONTH.LAST(TheDate) + 1) gives you the first day of the following month.
Quarters are a little trickier, you probably do need a custom routine. Examine the supplied routines as prototypes.

Jamesvanam · Post by **Jamesvanam** » Tue Sep 14, 2004 9:04 am

Thanks Ray,
I wasn't able to figure out one thing from doc's for Quarter.Last transform. it says the input will take Input date format in (YYYY-MM) but it doesn't work when I give this format of the input date. does it need a input in the Quater format like year and Quarter.

and One More question can you tell me where I can find all the different Conversion codes for Iconv and Oconv, the docs on'y has a few. I was wondering if there are any more or that is it.
Thanks
vanam

Jamesvanam · Post by **Jamesvanam** » Tue Sep 14, 2004 10:21 am

I wrote a simple nextquarter routine. it works fine.
Thank you for your suggestion Ray,
Vanam

ray.wurlod · Post by **ray.wurlod** » Tue Sep 14, 2004 4:07 pm

When in Designer or Manager invoke Help.
Select the topic BASIC Tasks.
Drill down from there:
Data Formatting
Oconv
(read it all)
(at this point you will have all the codes - follow the hyperlink to each for detailed explanation and examples)

In the DataStage BASIC manual read the appendix called "Correlative and Conversion Codes" (Appendix C, from memory).