data validation in google form

I am trying to figure out how i can force someone to specify a date in a particular format.  For example, the question might be, "What date are you available to start?"  if the user were to type 6/1/14, 6/01/14, 06/01/14, etc it would end up getting submitted as 06/14/2014.  I've tried messing with data validation in the form but couldnt get it to work.

Thanks
colonialiu20Asked:
Who is Participating?
 
Zack BarresseConnect With a Mentor CEOCommented:
Hi there,

If you're using a spreadsheet with cells pre-formatted how you want should retain that format so long as a valid date was entered. So it shouldn't matter if someone enters '6/1/14' or '6/01/14', the formatting should remain whatever has been set to that cell(s).

I'm assuming using the Excel web app is not an option? If it is, this is easily done in Excel.

If it's a Google Docs form, what is the type? I'm assuming it's not a date item, must be a textbox? If text, what kind of validation are you using? Using an actual 'date' type should resolve this.

Regards,
Zack Barresse
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.