MVSFORUMS.com

psridhar · Beginner Joined: 16 May 2004 Posts: 68 Topics: 26

Hi

I have my date as year and no of days in that year as below.

Year : 2005
No of days in that year : 306

Is there a way to convert this in to DD.MM.YYYY format...

For the above example, output should be 02.11.2005

Thanks in advance
Sridhar P

ofer71 · Posted: Mon Feb 06, 2006 8:14 am Post subject:

Here is an example:

psridhar · Beginner Joined: 16 May 2004 Posts: 68 Topics: 26

Hi Friend,

Thanks for the info. It solved my purpose.

Regards
Sridhar P

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

As a review, the DATE function used in this manner is specified as:

DATE(date_format1 , input_date , date_format2)

where

date_format1 is the format of the date you wish to convert to.
input_date is the date value.
date_format2 is the format of the input_date.

robr · Beginner Joined: 28 Apr 2006 Posts: 2 Topics: 0

To reactivate this old thread, why do I get "Incorrect call to routine" for this:

say date("J","31/12/99","E")

I hope to see 99365.

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

See the note on the use of DATE(J):

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IKJ4A360/4.3.16?DT=20050714012324

kolusu · Posted: Wed Jun 27, 2007 1:12 pm Post subject:

robr,

The error is because when Julian is used for date_format1, this option is valid only when input_date is not specified.

Try this

robr · Beginner Joined: 28 Apr 2006 Posts: 2 Topics: 0

Thx, I assume that means that the only solution is to create a separate routine to calculate the Julian date myself Crying or Very sad

One wonders why the date function has such a strange restriction...