Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display blank date in crystal report
Message
From
09/12/2004 05:37:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
08/12/2004 21:13:16
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
00967920
Message ID:
00967968
Views:
18
>Hi,
>
>I am using Crystal report for reporting data from dbf table. However It could not display the correct date if the date is blank. e.g. invdate = {//}
>in crystal report will display = 30/12/1899.
>
>Thanks for your help.
>
>regards,
>Kusnardi

Try setting field as nullable and replace empty with .null.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform