IBM Mainframe Forum

I have the following in my sortin file: DATE: 20 JUN 2010

Is it possible to convert this date to 2010-06-21 and also add that it is the 25th week of the year?
so the output file would look like:
2010-06-21,25

Both the input and output files are LRECL=80,BLKSIZE=800,RECFM=FB

thanks,
David

Hi Dohara,
I am not sure if a REXX code can solve your problem. If you can execute the below REXX code then you can get the desired output.

dohara,

What is the position of the date? It is easy to get the date transformed into format you need. However week number is going to be a little work. Do you need the weeknum in standard US format where the week begins with SUNDAY or ISO format?

bala1,

OP needs the date from the input file to be modified to Gregorian format and NOT the current date. Dividing by 7 to get the week number is NOT the right way to get the week number.

Hi guys

taking another read of my first post, it seems i did not provide the necessary info. I'm sorry about that.

So the thing is in this particular case using REXX is unfortunately not an option.
I can only use JCL and thus i was thinking if DFSORT or ICETOOL have got the power to do the date conversion.

In the input file i have the following: DATE: 21 JUN 2010
and this should be converted into 2010-06-21 also it would be great if the number of the given week could be calculated from this date so the output should
look like:

2010-06-21,25

I need the week number in ISO format - week starting with Monday.
As you say deviding the number of the given day of the year with 7 is unfortunately not the right way to get around to finding the week number.
It would only work if January 1 was always monday - as it's not the case, it's quite a bit of thinking to do it even in rexx.
eg. this year - 2010 - Jan 1 was friday and that week was the 53th week of the last year. The first week of this year starts with Jan 4, which is the first monday in 2010.

I'm not aware of any existing REXX function that calculates the week number. If you know one, please let me know.
I used to spend hours to write my own. It's working but it's nasty. Would be happy to use a standard one.

thanks,
David

Hi Kolusu,

Its possible to convert any date to the required format.

And for your kind information the calculation WEEKN varible I have used the integer divide arithmetic operators (%) and hence it would be the no of weeks completed for that particular date...


Hi David,
My apologies for not providing you the exact approach not an expert in ICETOOL , but you can execute rexx through JCL. which can have an PS file as an input and can write into an output file.

Bala1 wrote:Hi Kolusu, Its possible to convert any date to the required format.

Bala1,

I am aware of the fact that you can read an input dataset and perform the conversion in rexx. But your posted example doesn't show that. And REXX is a CPU HOG when you have millions of records to process.

And for your kind information the calculation WEEKN varible I have used the integer divide arithmetic operators (%) and hence it would be the no of weeks completed for that particular date...

*Sigh* The week number isn't that easy as you think. For example take January 1st 2010 . According to you it is week 0. But in reality according ISO standards it is week 53.

Hi Bala1

Appended is a batchjob that lets you get the week-number of a given date by using DFSORT:

I'm sure there are easier ways to do it, but it seems to work.

Cheers

Thomas