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
Find day of the next month
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Tue May 18, 2004 10:51 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 40
- Joined: Tue May 18, 2004 10:51 pm
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
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
-
- Participant
- Posts: 40
- Joined: Tue May 18, 2004 10:51 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.