Welcome Guest, Not a member yet? Register   Sign In
Date > then today?
#1

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

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

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

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




Theme © iAndrew 2016 - Forum software by © MyBB