Importing Dates

[Bart Pietercil]

When your text file has different datetypes I've always found it  
useful to import the dates as strings and
, once the import is done, process the datevalues (now strings) with a  
stored procedure looping over the imported set and cleaning out the  
dates as needed.

hth

Bart
On 23 Aug 2009, at 19:57, Ruslan Zasukhin wrote:

> On 8/23/09 4:18 PM, "Greg Olson-Hyde" <greg at hawkmount.com> wrote:
>
>>
>> On 23/08/2009, at 8:37 PM, Ruslan Zasukhin wrote:
>>
>>> 2) text file should keep ALL dates in the same format of course.
>>
>> So, I do have to change all my dates to conform with the Valentina
>> standard -  which appears to me to be nn/nn/nnnn is that correct?
>
> NO.
>
> Valentina on default use SYSTEM settings.
>
> But you can change in CODE to anything you way
>
>    YMD
>    MDY
>    DMY
>    ...
>
> You can use separator - or /
>
>
> Up to you
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina