RE: Case stmt in SQL

I can't help you wit this but I've always wondered what a JDE julian date
format looked like. Can you give an example?
-Bob Cozzi

Example of a JDE Julian Date : 104366 =  31 Dec 2004
The first digit identifies the century, the next two digits represent the
year, and the last three digits is the number days.



The opinions expressed within this email represent those of the individual and 
not necessarily those of Gullivers Travel Associates (GTA).
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify postmaster@xxxxxxxxxxxxxx
Should you wish to use email as a form of communication, GTA are unable to 
guarantee the security of email content outside of our own computer systems.



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________