CodeIgniter Forums
Date > then today? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Date > then today? (/thread-37155.html)



Date > then today? - El Forum - 12-29-2010

[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?


Date > then today? - El Forum - 12-29-2010

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

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


Date > then today? - El Forum - 12-29-2010

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