Last post Mar 15, 2011 08:55 AM by sansan
Mar 15, 2011 06:53 AM|ashish_ksharma1227|LINK
I am designing a crystal report when i am retrive date in crystal report.
As DB can not store Null value of date type it store Defualt date like"01-01-1900" when trying to store null.
when i am retriving those field in crystal report its show 01-Jan-1900"
Is there is any opetion to prevent show 01-Jan-1900.
Actully i want that if actual date is there it show but if 01-Jan-1900 its show blank or"--".
Mar 15, 2011 08:55 AM|sansan|LINK
You can use CASE in your select statement
WHEN DateColumn=CONVERT(DATETIME,'01/01/1900') THEN ''
ELSE DateColumn END DateColumn