Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get blank dates to return from VFP data
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00966206
Message ID:
00966468
Views:
8
This message has been marked as a message which has helped to the initial question of the thread.
That's what the ODBC driver is returning. It has nothing to do with Crystal. You'll have to write a formula in Crystal to look for that specific date and then make it blank.

>ODBC with a system DSN. I toggled the NULL setting in the properties of the DSN. It didn't seem to make a difference. If I set the select in Crystal to any value for the date field I get the 12/30/1899 date that I expect for a NULL.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform