SQL Date Filter not working

[karlstadick]

Hi!

I am expecting this query to only provide me information after the Date

select Date, ID, Activity
from [AZ].[dbo].[VW_ActivityDetails]
where Date > '07-01-2020'
order by Date

I have tried using some CONVERT functions on the Date field but they haven't worked.

I am sure it is something simple but I haven't been able to figure it out.

Thank you in advance for your ideas.

Karl

 

[mrshl9898]

Try 'YYYY-MM-DD'

 

[karlstadick]

Hi!

I have tried the following with no success:

CONVERT(VARCHAR(10), cast(Date as date), 101)
CONVERT(VARCHAR(10), Date, 101)
CONVERT(VARCHAR(10), Date, 103)


I have created and used a number of Date filters before but not necessarily on this database. Not sure why it isn't "behaving".

Also, there is no time stamp for this column in the database. This is fine as I don't need it; I simply need to filter on Date.

Any other thoughts?

Thank you!

Karl

 

[Norie]

Karl

How/where are you trying to run this query?

 

[karlstadick]

I am running it on MS SQL Server 2012.

Nothing fancy...just simply executing the query.

Done this many times on different databases with no issue. For some reason, the Date field isn't filtering properly.

 

[Norie]

Sorry to ask again but how/where are you trying to run this query?

Are you connecting to the database via ADO in VBA?

Are you executing it in SMSS?

 

[Fazza]

? - is the field really called Date