Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty Date
Message
From
05/05/2006 23:52:11
 
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Miscellaneous
Thread ID:
01113480
Message ID:
01119841
Views:
14
Crystal will interpret blank date values to some random date in the year 1800's.
You can write the following code in the SUPPRESS button of the date field

year({po_master.po_date})<1900



>Hello,
>
>I have a datetime field in a report. If the date is empty, I want to print "____/____/_____". If the date is filled in, I want to print the date.
>
>How do I test to see if the datetime field is empty and write the formula in Crystal Report version 9 to either display the datetime in a string or the blank line in a string?
>
>Thanks,
>
>TFISHER
Sanjay Dhiraj Patel

MCSE, MCDBA

Net2Biz (Thailand)
Previous
Reply
Map
View

Click here to load this message in the networking platform