comparing database date with system date, what's wrong with..

[amorphis88]

"SELECT * FROM tblKalender order by datum asc where datum > '" + Format(System.DateTime.Now, "MM-dd-yy") + "'"

[DB_err]

What type of error message are you getting?

HEre are two things I see at first glance.

1.
the "order by" section should come after the "where statement"

"SELECT * FROM tblKalender where datum > '" + Format(System.DateTime.Now, "MM-dd-yy") + "' order by datum asc"

2.
The code is comparing the field "datum" with a text string. Is the "datum" field a text string?

[amorphis88]

the query is ok but it doesn't do what i want..

http://www.chirolonderzeel.be/ASP2/kalender.aspx

the event "TEST" on the second of august shouldn't be displayed because the date is BEFORE systemdate

[DB_err]

What dbms are you using? If this were Oracle for example, and the datum field was configured as a date field, the following should work.

SELECT * FROM tblKalender where datum > sysdate order by datum asc

[chithrasujith]

Try this

SELECT EventDate, Activity FROM Dani_Table  WHERE (EventDate > GETDATE()) order by EventDate asc