Data Validation - custom date format dd-mm-yy

[dommmm]

Hi,
I'm trying to add a date validation for a cell (or column of cells) containing a custom date format of dd-mm-yy
I need to keep the data in format of dd-mm-yy because it's copied and used in an SQL Insert statement which needs the date in that format.

I'm trying to add a validation so that people can't add a date less than today ( ) but it's not working and I think it's because of the format of the cells.

I have:

and cells are formatted as:

Using the standard date validation doesn't work and allows and date to be typed in, in fact allows any entry.

Please help.

 

[JimM]

Don't you want the 'Data' box to be set to 'greater than or equal to'

 

[dommmm]

Don't you want the 'Data' box to be set to 'greater than or equal to'

OMG yes !! Thank you