Importing Dates

[Ruslan Zasukhin]

On 8/23/09 3:18 AM, "Greg Olson-Hyde" <greg at hawkmount.com> wrote:

Hi Greg,

1) In Valentina you can find
    db.DateTimeFormat
    db.DateSep
    db.TimeSep

Properties to tune this issue

2) text file should keep ALL dates in the same format of course.

 
> I am trying to import dates. They are in various formats in a text file.
> 
> 01.01.2006 - Will not import - it displays <NULL>, or, if 'Nullable'
> is Off it displays 00/00/0000.
> 01/01/2006 - Will import and display properly.
> 
> Is there a way around this, or do I have to convert all my dates to
> "/" separators.
> 
> I have found a page for importing ODBC but can't find any info on
> importing text - any help there?



-- 
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]