Hello Tony,

The Date Question type should be avoided, this field is great for Birthdate, Credit Card Expiration dates, etc..

But I would recommend that you make this a Question Type = Textbox. You can even include a jQuery Datepicker to allow the user to select a date from a great looking calendar. You'll see this plugin here:

http://jqueryui.com/datepicker/


The same SQL Validation you have above should work with a Question Type = Textbox.

Please let me know if you have any questions.

Thanks,

Ryan

Ryan,
The problem is the validation not the data entry portion. Wouldn't the examples you cited (Birthday, etc.) have the same problems as they can't be validated properly?

Thanks,
Tony

Hello Tony,

The Date Question Type allows several different combinations. Such as textbox, 3 combo boxes(month, day, year), 2 combo boxes (month, year). So you can definitely restrict the inputs when it comes to dates by using the combo box options.

When using the Date Question with Textbox/free form entry, if any date provided is invalid, then on submission this explains why you're receiving the "Error saving date response" response. This is according to a built in validation that occurs upon server side.

You can also make your validation instead of SQL validation into a Client Side(JavaScript) validation to check on the fly if the date inputted is valid or invalid and act appropriately.


OR your SQL Validation can become:

--------------------------------------------------------------------------------------------------------
DECLARE @var1 nvarchar(200)

IF '$(DateField)' = 'Error saving date response'
BEGIN
SELECT 'False' As IsValid
END

ELSE
BEGIN
SELECT 'True' As IsValid
END
--------------------------------------------------------------------------------------------------------

Please let me know if you have any questions.

Thanks,

Ryan