JDE date format

Hi List,

When dates are stored in OneWorld tables they are held in the JDE data
format - does anyone know how these are converted / translated ? (is it
a BSFN that does it or the ODBC driver ?).

We have an issue whereby the job queue has 'stopped' and also new jobs
cant be submitted. When a new report is ordered, the JDENet process (on
the server) that carries out the SQL statement to INSERT in to F986110
fails and the debug trace shows it is trying to use a value of
'04/12/2003' in the date column whereas it should be something like
103338 in JDE format.

I am not clear where this conversion is supposed to take place - any
ideas anyone ?

Thanks, regards,

Xe Intel Win2K, SQL7


Andy Smith
Technical Consultant


WHITEHOUSE

Consultants

http://www.whitehouse-consult.co.uk

Office: 01564 711037
Direct: 01159 825987
Mobile: 07949 603770

E-Mail: [email protected]




Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe

Andy,

There is a date conversion business function. Well, in fact there are a couple lying around in the codebase.

However, if this happened suddenly, I would check the datasource definition of the Server Map. Perhaps the Julian Date option was unchecked somehow. It is the datasource definiton that will tell the middleware what to do.

Regards,

It was indeed that the server map data source had the julian date
unchecked. The audit field showed this was changed at mid day on
Wednesday - exactly when the queue stopped working ! it also showed by
who !

Spot on Justin, cheers



Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe