Date in SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Drew - 09 May 2005 16:39 GMT

I have a report that displays an Employee's information. The database has
the following fields,

EmpID,
EmpFName,
EmpLName,
EmpMName,
PosID,
EmpAddress,
EmpStartDate,
EmpSepDate

The problem I am having is that the EmpStartDate and EmpSepDate have the
following data,

1900-01-01 00:00:00.000

On the report, it shows as 12:00:00AM. I need to only show the date only if
it isn't as above. I have tried the following,

=IIf([EmpSepDate]="1900-01-01 00:00:00.000","",[EmpSepDate])

Thanks,
Drew

Reply to this Message

Pieter Wijnen - 09 May 2005 20:05 GMT

I'd update all default dates to NULL which offcourse needs to be taken into
consideration when running queries

HTH

Pieter

>I have a report that displays an Employee's information. The database has
>the following fields,
[quoted text clipped - 20 lines]
> Thanks,
> Drew

Reply to this Message

ËÎ - 31 May 2005 13:20 GMT

> I have a report that displays an Employee's information. The database has
> the following fields,
[quoted text clipped - 20 lines]
> Thanks,
> Drew

Reply to this Message

ËÎ - 31 May 2005 13:20 GMT

> I have a report that displays an Employee's information. The database has
> the following fields,
[quoted text clipped - 20 lines]
> Thanks,
> Drew

Reply to this Message