General information
Title:
Importing from Excel-strange results
I am importing data from an Excel spreadsheet
Import From (m.xlsfile) Type Xl8 Sheet "new order file"
Which creates a new .dbf with fields "a", "b", "c", etc.
In the original spreadsheet is a field whose contents represent a time...
9:00:00 PM
...however, once it's imported it looks like this...
12/30/99 09:0
...then further down in my code I use the value scattered from the new .dbf and attach this information to some text (field name=P)...
comment3="Hard Start Time: "+Alltrim(M.p)+'. '
...and the value of comment3 becomes
Hard Start Time: 9:00:00 AM.
I have no idea where the AM part is coming from. Can anyone explain to me what's happening here and/or just how to get it to reflect AM/PM correctly?
Thanks,
Martha
Next
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