Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date column in export to spreadsheet
Message
From
30/06/2016 01:02:08
 
 
To
29/06/2016 17:48:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01637821
Message ID:
01637822
Views:
53
>I have a very simple file with only a few records at a time to export to a spreadsheet, and use the following to achieve this:
>
>
>copy to xyz type xl5 
>
>
>All worked fine until I had to add a date field.
>
>Can anyone tell me how to get the column in the spreadsheet to also be a date field
>
>Many thanks!

There should be no problem at all, with both date and datetime data types. Just remember that, in Excel, date, datetime, and time are numbers, and you can represent them as such. What are you getting / viewing when you open the Excel document, and what should be there?
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform