Did a litte research on the forums but i'm not able to find the solutions for my problems.

I've got a MySQL database with "datofelt" which is TIMESTAMP. Now in my recordset i want to filter out those who are >=thisdate. The Date() method which I used back in the old MS Access times does not work.

If I use:
WHERE datofelt >=now()
I get no results because now needs exactly now, in date,minutes,seconds.

Any solutions?

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MySQL

try this

WHERE datofelt >= CURDATE()

does it work?


------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

Yes indeed! Thank you <b>very</b> much <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MySQL