Do you have the sequence set as well
TIME format HH:MM:SS
TIME sequence HHMMSS
What version of RBase are you using?
Jim Limburg
Doug Daily wrote:
>
> 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
