Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appe from csv not recognizing date
Message
From
27/07/2008 06:29:50
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01334224
Message ID:
01334314
Views:
15
I don't know, sounds to be more explicit.
Cetin

>Hi Cetin. Thanks for your reply.
>I had coded round the problem by appending into a Text field and doing a CTOD which worked.
>
>Funny, I just tried again appending to a Date field and it seems to have worjked ok, even with 13 in day field ..dont know why.
>
>I normally have set date british.. is there a difference with set date to dmy ?
>
>Regards,
>Gerard
>
>
>>>Hi.
>>>I am using Append from Myfile.tx type csv and one of the fields is a date field
>>> in format dd/mm/yyyy e.g. 31/12/2008
>>>I have Set date british but any dates with a day greater than 12, its importing incorrectly,
>>> as if its set to US date format
>>>
>>>Is there any way to import British dates from CSV file ?
>>>
>>>Regards,
>>>Gerard
>>
>>
>>set date to dmy
>>append from mycsv.csv type delimited && for !empty(myDate)
>>
>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform