Thanks again for your help.

I get the following error with the SQL statement:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

I know how to...

Thanks John

I know what you mean am going to try and merge the data, without breaking the current system

2006-05-18 00:00:00.0002006-05-22 00:00:00.000

2006-04-13 00:00:00.0002006-04-13 00:00:00.000

2006-05-19 00:00:00.0002006-05-19 00:00:00.000

2006-09-20 00:00:00.0002006-09-20 00:00:00.000

2006-04-12 00:00:00.0002006-04-13 00:00:00.000

2006-04-19 00:00:00.0002006-04-19...

Thanks so far, given me some ideas, though that last one didn't work only brought out records that have the startdate as today, but I need to get records whose...

John...

Its an old system I inherited and for one reason or another cannot be changed much, but working on that. It was so a user can enter their own dates...

Yeah I have the option to do this, not something I've ever to do before.

I can do, not help much they are just simple SELECT statements, they are only in views for security reasons.

tblStaffList

CREATE VIEW [dbo].[vwStaffList]

AS

SELECT StaffID, StaffName, StaffInitials, StaffEmail,...