Re: Julian dates in PeopleSoft

[Gary Lane <Gary.Lane@BELL-ATL.COM>]

Dean,


Look in DATEMATH.SQC.  There are several routines that may be of help.

1. dtu-ser-to-ymd - This routine will take a Julian date and return
year, month and day.  You then can use dtu-format-date which takes year,
month and day and returns the ddate in yyyy-mm-dd format.  From this
point the format-datetime routine which is found in DATETIME.SQC can be
used to format the date in native format or other desired formats.

Hope this helps.