Error with Type Mismatch

Hey there, I am trying to check a user input to see if the user has entered the date correctly.

I am using the code below but it keeps giving me a "Type Mismatch" error. Does anyone know where I am going wrong?

Please Login or Register  to view this content.

Any help would be greatly appreciated, thanks.

Jag

First time into the function the argument is blank,

Try moving the test to the end of the loop

Please Login or Register  to view this content.

Whenever a non-numeric string is passed to the date_check function the Cast to Date will generate a debug.

Could you not allow any date format and simply format result per requirements, eg:

Please Login or Register  to view this content.

It's not clear how the string equivalent of the Date is being used but the strDate is there to demo the principle.