Date in SQL Server

  • Thread starter Thread starter Drew
  • Start date Start date
D

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
 
I'd update all default dates to NULL which offcourse needs to be taken into
consideration when running queries

HTH

Pieter
 
Drew said:
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
Click to expand...
 
Drew said:
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
Click to expand...
 
Back
Top