Doug,
If 2001/06/13 0:00:00 becomes
2001/06/13 0:00:00 00:00:00
maybe it's not the leading 0s but RBase is seeing the blank in
between as a delimiter. Datetime is just adding in the 0:00:00 to
complete its formatting (??).
Try setting space to ~ or | before the load. FWIW, I always set
delimit and space to some odd characters before unloading/loading
to avoid this type of problem.
Ben Petersen
On 12 Jul 2001, at 11:02, 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
>
>
>
>
