General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
>I have an Excel sheet with several columns of dates.
>
>When I import the file into VFP (or save as DBF) the dates are converted to a number.
>
>The dates do not appear to be julian date because 04/30/99 translates to 36297
>
>If you do ? sys(10,36297) it converts to a blank date.
>
>? sys(1) gives a date number of 2453439 for today.
>
>How can I convert 36297 to 04/30/99 ?
What version of Excel are the sheets stored as? Which command are you using to import?
As I remember it, this is a problem with earlier versions of Excel, but should work for later versions.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only