There are ways you can manipulate the date in Query, but they are a pain and
you have to remember them each time. The easiest way we found was to create
a table with the last five years and a few years in the future of about
every other data format imaginable, including the JDE-style Julian Data.
Then you can link to that table in your queries. Here is our file format.
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
JULDT ZONED 6 0 6 1 Both JULDT
Field text . . . . . . . . . . . . . . . : CYYDDD
MDYDT ZONED 6 0 6 7 Both MDYDT
Field text . . . . . . . . . . . . . . . : MMDDYY
MDYFMT CHAR 8 8 13 Both MDYFMT
Field text . . . . . . . . . . . . . . . : Formated MM/DD/YY
Coded Character Set Identifier . . . . . : 37
YMDDT ZONED 6 0 6 21 Both YMDDT
Field text . . . . . . . . . . . . . . . : YYMMDD
YMDFMT CHAR 8 8 27 Both YMDFMT
Field text . . . . . . . . . . . . . . . : Formated YY/MM/DD
Coded Character Set Identifier . . . . . : 37
DMYDT ZONED 6 0 6 35 Both DMYDT
Field text . . . . . . . . . . . . . . . : DDMMYY
DMYFMT CHAR 8 8 41 Both DMYFMT
Field text . . . . . . . . . . . . . . . : Formated DD/MM/YY
Coded Character Set Identifier . . . . . : 37
ISODT ZONED 8 0 8 49 Both ISODT
Field text . . . . . . . . . . . . . . . : YYYYMMDD
ISOFMT CHAR 10 10 57 Both ISOFMT
Field text . . . . . . . . . . . . . . . : YYYY/MM/DD
Coded Character Set Identifier . . . . . : 37
USADT ZONED 8 0 8 67 Both USADT
Field text . . . . . . . . . . . . . . . : MMDDYYYY
USAFMT CHAR 10 10 75 Both USAFMT
Field text . . . . . . . . . . . . . . . : MM/DD/YYYY
Coded Character Set Identifier . . . . . : 37
EURDT ZONED 8 0 8 85 Both EURDT
Field text . . . . . . . . . . . . . . . : DDMMYYYY
EURFMT CHAR 10 10 93 Both EURFMT
Field text . . . . . . . . . . . . . . . : DD/MM/YYYY
Coded Character Set Identifier . . . . . : 37
JULLDT ZONED 7 0 7 103 Both JULLDT
Field text . . . . . . . . . . . . . . . : YYYYDDD
DYOFWKID ZONED 2 0 2 110 Both DYOFWKID
Field text . . . . . . . . . . . . . . . : Day of the Week Indicator
DYOFWKDS CHAR 9 9 112 Both DYOFWKDS
Field text . . . . . . . . . . . . . . . : Day of the Week Description
Coded Character Set Identifier . . . . . : 37
CYMNTH ZONED 6 0 6 121 Both CYMNTH
Field text . . . . . . . . . . . . . . . : Year and Month YYYYMM
MONLY ZONED 2 0 2 127 Both MONLY
Field text . . . . . . . . . . . . . . . : Month Only
DONLY ZONED 2 0 2 129 Both DONLY
Field text . . . . . . . . . . . . . . . : Day Only
CYONLY ZONED 4 0 4 131 Both CYONLY
Field text . . . . . . . . . . . . . . . : Year Only YYYY
YONLY ZONED 2 0 2 135 Both YONLY
Field text . . . . . . . . . . . . . . . : Year Only YY
CIND ZONED 1 0 1 137 Both CIND
Field text . . . . . . . . . . . . . . . : Century Indicator 0 or 1
CYIND ZONED 2 0 2 138 Both CYIND
Field text . . . . . . . . . . . . . . . : Century Code 19 or 20
LEAPYR CHAR 1 1 140 Both LEAPYR
Field text . . . . . . . . . . . . . . . : Leap Year Ind (Y N)
Coded Character Set Identifier . . . . . : 37
DYFORXLS ZONED 7 0 7 141 Both DYFORXLS
Field text . . . . . . . . . . . . . . . : Days within .xls
_____
From:
[email protected] [mailto:
[email protected]] On
Behalf Of Bill Meyer
Sent: Tuesday, February 01, 2005 8:33 AM
To:
[email protected]
Subject: Julian date conversion -
Perhaps someone can help. .I am using As400 Query on File F4111. The dates
eventually downloaded to Excel are in Julian date format. Any ideas on how
to convert Julian dates to regular date formats.
_____
The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.
Looking for a job? Check out the Job
forum
This is the JDELIST EnterpriseOne and World Applications Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.