Conversion failed when converting date and/or time from character string

Question

I'm trying to execute the following query, and it shows me the error in the title,I'm not converting date or time here.Not sure why its showing the error.

select *    
from [dbo].[Data]    
where [Report Month] between '2015-05-01' and '2015-06-31'     
  and [FTE Status]='Inactive'

Thanks in Advance!

duffn · Accepted Answer · 2015-08-10 16:54:31Z

4

There is no such day as June 31st.

answered Aug 10, 2015 at 16:54

duffn

3,7908 gold badges39 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Give_me_data Over a year ago

My bad,Thank you Bud!

Collectives™ on Stack Overflow

Conversion failed when converting date and/or time from character string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related