Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Finding the Data You Want Filtering by Dates

Posted by Wufei Hong
Wufei Hong
1,393 Points

don't know what's wrong wiz my code

why I entered SELECT * FROM results WHERE away_team="Hessle" AND played_on >= "2015-10-1" , it tells me that I missed the date 2015-10-1

1 Answer

Steven Parker
Steven Parker
231,172 Points
Steven Parker
Steven Parker
231,172 Points

If you look carefully at the response message that you get:
  Bummer: You're missing the date of the 1st October 2015 ("2015-10-01") :point_left:

You'll notice the date includes "01" and not just "1" at the end. The width of the date components is important for them to be properly recognized.

So just add the "0" and you'll pass.