NOt clear, how do you use Alltrim(M.p). When you import, the field type becames Datetime, or what? If it is Datetime, then Alltrim(p) should give an error.

With Datetime field, it should have P.M. as in the Excel file, or should be converted to 21:00 if you have set hours to 24.
Then ttoc(field_name,2) should give you the proper time.


>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