Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference in Date Save between VPP 7 & FPD
Message
From
27/09/2006 06:34:43
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01157275
Message ID:
01157424
Views:
23
>>>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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform