It's actually a Lillian date. Good luck. <p>Dave

Lee McDowell wrote:<BR>
> I have an Excel file created by PeachTree with a date column. How do<BR>
> I upload to the AS/400 without the date field being converted to that<BR>
> julian-like number?<BR>
<P>
Lee,<BR>
<P>
Here's an example showing converting to and from a lillian date:<BR>
<a href="http://archive.midrange.com/rpg400-l/200105/msg00494.html">http://archive.midrange.com/rpg400-l/200105/msg00494.html</a><BR>
<P>
Bill<BR>
<P>
<P>

Thanks for the replies, however here is what I have learned so far. I had never heard the term Lilian Date before, so I started my search at that point. IBM has an API (CEEDATE) that gives you the number of days after the Lilian Day, 10/14/1582, which aparently is the date the Gregorian calendar started. This looked promising, I could upload my Excel file and just convert the date. Unfortunately, the Lilian-like number used by Excel is actually tne number of days since 01/01/1900. Well, back to my research. If anyone has a suggestion, I would like to hear it.

I have an Excel file created by PeachTree with a date column. How do I upload to the AS/400 without the date field being converted to that julian-like number?

Lee McDowell wrote:<BR>
> Thanks for the replies, however here is what I have learned so far. I<BR>
> had never heard the term Lilian Date before, so I started my search<BR>
> at that point. IBM has an API (CEEDATE) that gives you the number of<BR>
> days after the Lilian Day, 10/14/1582, which aparently is the date<BR>
> the Gregorian calendar started. This looked promising, I could upload<BR>
> my Excel file and just convert the date. Unfortunately, the<BR>
> Lilian-like number used by Excel is actually tne number of days since<BR>
> 01/01/1900. Well, back to my research. If anyone has a suggestion, I<BR>
> would like to hear it.<BR>
<P>
Lee,<BR>
<P>
It's just a bit more difficult. You just have to determine the difference<BR>
in the number of days between 10/14/1582 and 01/01/1900 and add the result<BR>
to the number coming in from Excel.<BR>
<P>
Bill<BR>
<P>
<P>