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

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Exported date to Excel won't format as date

Message

De

13/05/2009 10:15:48

Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia

À

13/05/2009 01:23:37

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, Inde

Information générale

Forum:

Visual FoxPro

Catégorie:

COM/DCOM et OLE Automation

Titre:

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

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Divers

Thread ID:

01399348

Message ID:

01399611

Vues:

47

>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