Yes, I made that change and of course there was no difference.

And I like what Lutz said, they asked for it; so what do they expect to get.

They were griping...

Thank you guys very, very, very much.

I am truly, truly grateful for everything.

They said they are getting too many blank(null values) for the following fieldnames:

ID number, Last and First Name, Defend Name, Hearing Type, Case Number, DA Number Event

Below is the...

Hi Lynn,

I have just sent them a copy of data generated.

Please give me a few minutes to get a feedback from the users.

Again, I am truly grateful for you guys'...

Yes, I read Lynn's posts a lot, just as much as I read yours and Sturner's.

As far as this thread is concerned, you are the star and 5 stars...

Man, you are SQL God; just adding right outer join showed the correct data.

I must have done something wrong because just before I posted it, I tried right outer join...

That ADDITIONAL table we just added maybe the problem because now, it has gone back to getting data that begin from March 16th.

Now, that shows the correct data.

It shows data from today till 2020, exactly what they want but not sure what/how those joins are affecting it.

I appreciate your patience and kindness.

Thanks Lutz, you are the greatest.

Are you saying to remove those 2 tables for now or just test with those 2 tables only for now?

Ok, I just ran it with...

Greetings again,

I know you have given detailed, solid explanations of different ways of using the functionDate and GetDate() and I am truly grateful.

However, please forgive me for revisiting this issue...

Lutz,

I can't thank you and the everyone else who assisted with this issue enough.

I can't thank you guys enough.

I just want to point out that I don't have the ability...

hi Jeff and Lutz

Here is the DDL (the relevant info).

CREATE TABLE [dbo].[myTable] (

[Key] [int] NOT NULL ,

[functionDate] [datetime] NULL ,

[EventTime] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

The...

WOW, I just love it when I see elaborate explanations such as yours.

Thanks a lot Jeff.

Your queries beg one question.

So, the only reason you used this -> getdate()) + 1...

Thanks a lot Jeff,

All I am trying clear up (for my current and fututre benefit) is that in a situation such as mine, where a fieldname is of DateTime datatype,...

Many thanks again Lutz but one more question.

Are you saying that just being of dateTime datatype, that last code you wrote would work even though, there is no time...