Arithmetic overflow error converting expression in to data type datetime

Hoping someone can help. I've looked on the internet for a solution but none seem to resolve it.

I want to query a large table and only get the results back where a column equals today's date.

Here's the query:

select [Table1].[Field1]
from [Table1]
where [Table1].[Field1] = GetDate()

The date format is as follows:

 20020630

I'm a beginner in SQL so any help would be really appreciated because I am growing fond of it.

Thank you!!! :)


ANSWERS:


To find the broken value:

select [Table1].[Field1]
from [Table1]
where ISDATE([Table1].[Field1]) = 0

GETDATE includes a time, so you need to remove this. This assumes SQL Server 2008+

select [Table1].[Field1]
from [Table1]
where [Table1].[Field1] = CAST(GetDate() AS date)


 MORE:


 ? Arithmetic overflow error converting expression to data type datetime (Int64 to datetime)
 ? Updating EF model throws ""Arithmetic overflow error converting expression to data type datetime"
 ? Arithmetic overflow error converting expression to data type datetime. in asp.net
 ? SQL Server Arithmetic overflow error converting expression to data type datetime
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? How to log SqlDataAdapter exceptions asynchronously?
 ? SqlDataAdapter not update database
 ? multithreading sqldatareader time expired
 ? multithreading sqldatareader time expired