Convert from julian to normal date

[Former Member]

Post Author: LADYLUV

CA Forum: Crystal Reports

My julian date is stored in the form 2957ZI, where the 1st 3 digits is the day and the 4th digit is the year, the last 2 has nothing to do with the date. How do I convert this to read 10/22/2007 in crystal reports?

Thanks

[Former Member]

Post Author: LADYLUV

CA Forum: Crystal Reports

Thank you very much. That worked perfectly.

[Former Member]

Post Author: SKodidine

CA Forum: Crystal Reports

dateserial(tonumber('200' & {table.date}[4]),1,tonumber({table.date}[1 to 3]));