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

Posted by Brenden Fowler
Brenden Fowler
5,556 Points

You're missing the value of "2015-09-01", and I'm not. (SQL)

Well I'm doing the code challenge in SQL basics, and it keeps telling me I'm missing the value of 2015-09-01. As you can see in my code, I'm not. If someone could explain what I'm doing wrong that would be awesome!

Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Hi Brendan,

We're not seeing your code. Could you post us the code and a link to the code challenge so we can take a look at it? :)

Thanks

Brenden Fowler
Brenden Fowler
5,556 Points

Here is my code (I thought Treehouse would put it in the question because there was a "Share my code" option with a checkmark)

SELECT * FROM results WHERE played_on BETWEEN 2015-09-01 AND 2015-09-30;

Brenden Fowler
Brenden Fowler
5,556 Points

I see what I did now The date needs to be in quotes (i.e "2015-09-01")

sulaiman abouabdah
sulaiman abouabdah
5,314 Points 
SELECT * FROM results WHERE played_on BETWEEN '2015-09-01' AND '2015-09-30';