Dean,
I wrote a function that converts full Julian dates (number of days since January 1, 0001) to an actual date, you could use this (along with the function I wrote to convert the other way).
You could convert December 31 of the prior year to a Julian date, add your number and then convert it back to a Gregorian date. you can look at the functions on the SQR user group web page (http://www.sqrug.com/) in the Library section... I believe it is in the #include section.
Hope this helps.
Later...
Rob
-----------------------------------------------------------
Through the NIC... Over the twisted pair...
Off the Router... >>SWISH<<... Nothing but NET!
-------------------+-------------------+-------------------
Robert Goshko | rgoshko@ibm.net | (403) 417-AXIS
Axis Developments | | Sherwood Park, AB
-----Original Message-----
From: MORRIS, Dean [SMTP:Dean.MORRIS@SUNCORP-METWAY.COM.AU]
Sent: Monday, January 05, 1998 5:58 PM
To: Multiple recipients of list SQR-USERS
Subject: Julian dates in PeopleSoft
Dear All,
I'm currently working on a PeopleSoft Financials v7 implementation on an
Oracle database.
We're trying to find a standard function that will translate a Julian
date into standard date format. ie. a number between 1 and 365 and
convert it to a 31-12-1997 type date. This logic is fairly easy to
write, but I was hoping to be able to use a standard SQR function to do
it. There does not seem to be one in the standard SQC files.
Can anyone help?
Thanks in advance.
Dean.
Unrecognized Data: application/ms-tnef