Cannot set validation rule on Date/Time type

[intheflesh77]

I need to restrict data input to the following: "09:00" Or "11:00" Or "13:30" Or "15:30"

This rule works when the data type is set to text, but not on Date/Time with short date set as format

I cannot understand why?



Can anyone help me get a Date/Time type to accept only one from these four values.

[intheflesh77]

Found solution:

#09:00:00# Or #11:00:00# Or #13:30:00# Or #15:30:00#

[pbaldy]

Thanks for posting your solution and welcome to the site!