Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appe from csv not recognizing date
Message
De
27/07/2008 06:29:50
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01334224
Message ID:
01334314
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform