cancerjenn
MIS
Well, here is my issue. I'm trying to export the date field from ONEWORLD Xe into crystal report 8.5. However, the date format that crystal report 8.5 uses is GREGORIAN calendar and OneWorld Xe uses the Julian calendar. So when I extract the date field from ONEWORLD Xe into crystal report 8.5 and using a function in CRYSTAL report8.5 called JuliantoDate
to convert the date into Gregorian, it gives me some werid numbers due to the decimal in the date field. So I was wondering if there is a way to truncate the decimals in the date field or convert it into a string before i use the JULIANTODATE function?
to convert the date into Gregorian, it gives me some werid numbers due to the decimal in the date field. So I was wondering if there is a way to truncate the decimals in the date field or convert it into a string before i use the JULIANTODATE function?