[ QUOTE ]
Hi Randy -
My understanding is that there is a custom Web Query data adapter for JDE environments which may already be handling conversion of Julian dates correctly. Did you ping IBM yet?
Would love to help, let me know if we can.
All my best,
Jen
Jenniefer Halverson
Client Partner Executive for i5/OS
Centerfield Technology, an IBM Business Partner
888.387.8119 EX 153
507.251.1281 MOBILE
Web:
http://www.centerfieldtechnology.com
Email:
[email protected]
[/ QUOTE ]
Yeah, there is one and I am using it with MS Query. For the life of me, I can't remember where I found it. I can only use it on my fat client. There is one out there, for about $1,500, that doesn't require a fat client.
It does the date conversions, add decimals to numeric fields, and gives you the option of field names or alias. If I can remember how i got it, I'll update.
Maybe another BSA can chime in.