Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difference in Date Save between VPP 7 & FPD
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01157275
Message ID:
01157427
Vues:
25
>>>>Interesting naming convention
>>>
>>>Which?
>>>
>>>>Your original table has date in character format. When you produce CSV can you change it to date (use CTOD, if you want)?
>>>
>>>Do you mean IntermTable? That has just been created by importing the XLS. How can I use CTOD() in that process?
>>>I had no initial input in the production of the XLS/CSV, but had to reformat it somewhat to get it to feed to this program.
>>>
>>>Si ... don't understand. Thanks
>>>
>>
>>I guess, I misundertstood you originally. Ok, your intermTable is from Excel, which explains strange names for the fields.
>
>What strange names? They're just field names as any other.
>
>>And in your IntermTable dates are in C format, correct?
>
>Correct - the XLS date field yields a char date field in IntermTable
>
>>What do you receive when you convert these dates back to date? Of they already come wrong?
>
>
>Replace	Operator	with tnOperator, ;	
>         ...
>  	Date with CTOD( m.E), ;
>         ...
>
>is in the code (as I posted). This is what yields dd/mm/1920 in the result FB1.DBF
>
>>
>>Thanks.

What you have in E field?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform