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

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?

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

Try this

SELECT EventDate, Activity FROM Dani_Table  WHERE (EventDate > GETDATE()) order by EventDate asc
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.