Is there a way to force the end user to enter a date parameter in a certain format when prompted via the query (e.g. 1/1/2014 (4-digit year)). I have users that accidentally enter 1/1/201 (forgetting the last digit of the year), and because 1/1/201 is a valid date, the query continues to run returning unexpected data results. Any thoughts? (PS: passing the date through a form is not an option for this project). Much thanks in advance!