Exported date to Excel won't format as date - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Exported date to Excel won't format as date

Message

From

13/05/2009 10:15:48

Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia

To

13/05/2009 01:23:37

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

General information

Forum:

Visual FoxPro

Category:

COM/DCOM and OLE Automation

Title:

Re: Exported date to Excel won't format as date

Environment versions

Visual FoxPro:

VFP 9 SP1

Miscellaneous

Thread ID:

01399348

Message ID:

01399611

Views:

45

>Hi Dragan
>
>>IOW, thing to try is to set date American before exporting.
>
>Thanks, SET DATE YMD worked for the moment :).

O tempora, o mores. Excel showing signs of an IQ larger than a US shoe size? Couldn't believe it would attempt that AND get it right.

Some of my recent experiences:

http://drfairday.blogspot.com/2009/04/another-excel-dialog-wins-over-logic.html
http://drfairday.blogspot.com/2008/08/it-is-not-formula-you-moron.html

back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.

Click here to load this message in the networking platform