how to get a blank date in Crystal report instead of 12/30/1899

Question

I am using crystal report and i an using a date parameter. In some cases i am not returning any date from database. The system is tracking a default date 12/30/1899. So in this case i want to bind the report with blank date. Need to show all other fields with blank date. Pls do an help for this

Thanks in advance Jidheesh

Answer 1

use this format in select query

select isnull(dateColumn,''),column2 from table