I am trying to load an ASCII comma delimited file that has
DATETIME info: example 2001-06-13 00:00:00
I have date format set to: YYYY/MM/DD
I have time format set to: HH:MM:SS
Rbase HELP shows DATETIME format for my above example would
be: 2001/06/13 0:00:00
The leading zero is causing problems on loading. The
date part loads fine, but the time dumps into the next field
so I get FIELD1 (datetime) and FIELD2 (text) loaded like:
FIELD1 FIELD2
2001/06/13 0:00:00 00:00:00
I cannot find any HELP as to whether you can format DATETIME
to actually recognize 00:00:00.
I know there's probably an easy answer out there. Sock it to me.
TIA.
Douglas Daily
Payroll Manager
Facilities Services, box 352215
206-221-4357
