I have to check if users have entered the date correctly in a file. The format should be like ‘MMM-YY’ like ‘FEB-17’ including the inverted comas.
the following will be incorrect:
FEB-17 <- Missing inverted comas
’Feb-17’ <- Not capitalised
’FEB 17’ <- Missing dash in the middle
’FEB-2017’ <- Year should be 2 digits
Is there an easy way to validate data entry?