Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to show empty date field in Excel ?
Message
From
14/11/2002 23:32:20
Handi Rusli
PT. Alam Sumbervita
Jakarta, Indonesia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to show empty date field in Excel ?
Miscellaneous
Thread ID:
00723055
Message ID:
00723055
Views:
42
Hi everybody :-)

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 ?

Any help will be appreciated ... thank's :-)

Note : I just 'throw' my table into Pivot Table Class, and Excel treat blank dates as 01/01/1900. (I'm using Office XP and VFP7 SP1)
Handi Rusli
"Treat people with respect and courtesy, and one will be blessed. Complete task heartily, with best effort and responsibility, and one can achieve the greatest."
Next
Reply
Map
View

Click here to load this message in the networking platform