That might explain alot, I am using 2005!!

thank you

I have no experience in CRL, so would like T-SQL for now please?

the answer to the second question is yes.

1. I would prefer t-SQL as CLR is way beyond my understanding

2. At the moment I'm not concerned about performance

Unfortunately i dont have the faintest idea.

Is there any way you can break it down for me?

Fantastic thank you

CREATE TABLE #mytable

( ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, ...

This is nothing to do with me wanting to export the report. When I do export the report it actually shows on one page, like I have done it on...

Hi Anthony these work. But where would I add the part to get records from the current time until before midnight?

It give me this error:

Msg 243, Level 16, State 1, Line 1

Type DATE is not a defined system type.

This still records I dont want to see?

In all of the functions you have given I am having to change 'DATE' to 'DATETIME' do you think this is why...

I want current time to 28/5/2012 23:59:999

For tomorrow

To see from current time till 29-05-2012 23:59:59.999 or 29-05-2012 00:00:00.000 to 29-05-2012 23:59:59.999

If from current time to midnight

WHERE

DueDate > GETDATE() AND DueDate < CONVERT(DATE,DATEADD(DAY,2,GETDATE()))

// Yes I require...

Yes fantastic that works. I did only want records for that day and after current time.

what would the logic be for tomorrow?

or this week?

This also returns records with the following due date 29/5/2012 00:00:000?

This returns everything for that day. But I only want to return everything for the day after the current time.