Project,
I guess the other guys didn't really understand your question? You wanted
to know how to convert YYMMDD to CCCDDD(JDE Format)?
I am quite handy with Access - This is an example of how you can convert the
dates in access. You can use similar logic inside VB, VBA, C, C++ and,
probably, CLP.
Recently I had to import a CSV Text file, with dates, into a JDE Z file.
The example is a little long, but I'll try to keep it clean.
Inside the text file there were dated in the following format - CCYYMMDD
(Your dates are similar).
* I imported the CSV's dates(DOB) as text - into an Access table.
* I added to new fields to the access table. One as an Access Date and the
other as numeric/integer.
* Using an update query, update the new date field with the following
formula: Mid([DOB],5,2) & "/" & Mid([DOB],7,2) & "/" & Mid([DOB],3,2).
This formula will dissect and concatenate the text field, DOB, from CCYYMMDD
to Access date format MM/DD/YY. For this example, I am updating the new
field DOBDATEFORMAT.
* Using a new update query, update the new Numeric field with the following
formula: Year([DOBDATEFORMAT])-1900 &
Format([DOBDATEFORMAT]-DateSerial(Year([DOBDATEFORMAT])-1,12,31),"000").
DOBDATEFORMAT is the converted text date. The numeric field will be updated
with a numeric equal to a JDE Julian Date.
You can then load the numeric/integer into a JDE table...
I know, it's a pain!
JDE - XE & AS/400
Daniel
[email protected]
www.existinglight.net
or my day job...
Daniel Bohner
Simplot Corporate Information Systems
Pioneer Building
Boise, ID 83702
(208)250-1917 personal cell
[email protected]
Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x