Date in SQL Server

[Drew]

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

 

[Pieter Wijnen]

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,

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

 

[ËÎ]

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