• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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!


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.