Hi,
I would like to create a combo box which shows some dates. As DefaultValue I'm using a SQL-Statement:
select FieldValue As QuestionOption, FieldValue As QuestionOptionValue
from UserDefinedData
WHERE UserDefinedFieldID = '30'
AND CONVERT(datetime, FieldValue) >= getdate()
Unfortunatelly I get an error: Explicit conversion from data type ntext to datetime is not allowed.
Is there a way to use getdate() with a SQL-Query? The field is a datetime-field within SQL-Server.
Best,
Jörg