Some clients have complained that the report CSV file opens up in excel with all the data in the first column only, instead of showing it in separate cells when …
A problem with SQL over JDE Data is the way Dates are stored in JD Edwards. JDE stores dates in Julian Format. The following SQL snippet can convert the Julian date into Gregorian Date format or Normal date.