3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by chithrasujith
0

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?

0

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
0

Try this

SELECT EventDate, Activity FROM Dani_Table  WHERE (EventDate > GETDATE()) order by EventDate asc
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.