Face palm. I love it.
Thanks!
Bruce
-------- Original Message --------
Subject: [RBASE-L] - Re: Gateway Excel Import TIME Wierdness
From: Albert Berry <[email protected]>
Date: Thu, June 14, 2012 2:25 pm
To: [email protected] (RBASE-L Mailing List)
I often bring Excel data into text columns, using a temporary table,
when there are dates and times and convert after.
Albert
On 14/06/2012 2:27 PM, Bruce Chitiea wrote:
> All:
>
> rbase 9.1_(64) 9.1.5.20510
> Windows 7
> MS Excel 2003
>
> My experience importing dates and times from Excel is spotty. For
> instance, times defined in Excel as '13:30' don't import at all.
>
> Does anyone have any dead-bang-always-work Excel formats for date and
> time columns?
>
> The target columns are appropriately defined with DATE or TIME data types.
>
> I'm using the RBase defaults for date and time formats:
>
> Date:
> Format: MM/DD/YYYY
> Sequence: MMDDYY
> Year: 30
> Century: 19
>
> Time:
> Format: HH:MM
> Sequence: HHMM
>
> TIA
>
> Bruce
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2012.0.2180 / Virus Database: 2433/5069 - Release Date: 06/14/12
>
