CodeIgniter Forums

Full Version: Date > then today?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]shenanigans01[/eluser]
I have a db table with a date field.
The dates are stored as "date" type in this format : 2011-01-14

I'm trying to-do a select dates where date > today
so it will only show dates after today, I can't get it to work though
even if i hardcore date > 2011-01-13 the 14th dosn't show up?

thoughts?

El Forum

[eluser]sooner[/eluser]
i am not sure this might be the problem.....

did you do date > '2011-01-13'....did u include quotes?

El Forum

[eluser]shenanigans01[/eluser]
that was the problem! awesome, thank you!