date shows 30/12/1899 for null

[PeriyurParthi]

hi all
i useing access table and the records which ever have dates like this "00:00:00" ie default date, in crystal reports its showing as 30/12/1899. either i have to hide that particular data or to be converted to 0, replies will be helpfull.
thanks
parthi

 

[kenhamady]

You can suppress the value using a condition that says something like:

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

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[dgillz]

Or set your report to "convert null field values to default".

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[kenhamady]

Except, I am not sure these are considered truly NULL.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Madawc]

What I think you've got is an SQL value, a 'smalldatetime' which stores time as minutes since a given date. Zero minutes is 1st Jan 1900 on our system, but I suppose they vary.

I'd use a formula field, with something like
If {Date} < datetime(1901, 1, 1)
then &quot;No date&quot;
else totext ({Date}, &quot;dd/MM/yyyy&quot

In Crystal 8.5, you have lots of other formats to display your dates.

Madawc Williams
East Anglia, Great Britain