Geek asks and answers

How to get an empty date in a Crystal report instead of 12/30/1899

I am using a crystal report and using the date parameter. In some cases, I do not return the date from the database. The system keeps track of the default date 12/30/1899. Therefore, in this case, I want to associate the report with an empty date. It is necessary to show all other fields with an empty date. Pls help with this

Thanks in advance Jidheesh

+5
source share
2 answers

use this format in the selected query

select isnull(dateColumn,''),column2 from table
+2
source

In the field added to the report, go to “Format the object” and check the “Suppress” box, then add this formula by clicking at the bottom right of this chackbox:

{DATE_FIELD} = Date (1899,12,30)

Where DATE_FIELD is the field of your object.

, 1899/12/30.

0

More articles:


All Articles