Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to show empty date field in Excel ?
Message
 
To
14/11/2002 23:32:20
Handi Rusli
PT. Alam Sumbervita
Jakarta, Indonesia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00723055
Message ID:
00723058
Views:
9
>Anybody know how to show empty date field in Excel
>using PivotTable Automation (VFP Foundation Class)?
>Excel converts blank dates with "01-01-1900". Any
>issues around this ?

The first thing that comes to mind is changing the empty dates into NULL dates. The second thing is running a macro in Excel that blanks those fields out.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform