tpayne
Reputable Poster
I need to upload an Excel file containing dates into JDE.
If the columns are formatted as dates in Excel (which is best for the user as they need to be able to manipulate them), when they are uploaded to the AS400 they appear as an integer, which I believe is the number of days since 1st January 1900 (or something like that).
Is there another way to upload dates to the AS400 so that they appear either as JDE style Julian dates or as MMDDYY (any sequence)?
Or failing that, is there a routine that converts an AS400 Julian date to a JDE Julian date?
I can write one, but I hate re-inventing the wheel...
Thanks in advance.
If the columns are formatted as dates in Excel (which is best for the user as they need to be able to manipulate them), when they are uploaded to the AS400 they appear as an integer, which I believe is the number of days since 1st January 1900 (or something like that).
Is there another way to upload dates to the AS400 so that they appear either as JDE style Julian dates or as MMDDYY (any sequence)?
Or failing that, is there a routine that converts an AS400 Julian date to a JDE Julian date?
I can write one, but I hate re-inventing the wheel...
Thanks in advance.