I have created a new Bizform and I would like a drop-down list box to pick up a list of specific dated news items e.g. '24/11/2006 Company Meeting' My initial attempt was:

SELECT CONVERT(VARCHAR, EventDate, 3), NewsTitle FROM CONTENT_News WHERE NewsCategory = 5

But this is not working, well more specifically it seems that the convert is the issue. Can I code a datetime to string convertion in a bizform field query? or maybe i have to do something like this:

http://www.kentico.com/Forums/ShowPost.aspx?PostID=886

any help would be appreciated.