On a date/time field, I want to put in a validation rule for user to only put top of the hour. This means they can't put 1:15pm, 1:30PM, 1:45pm. They can only do 2pm,3pm,4pm, etc.
4 Antworten
Please try below formula, worked for me.
MOD( VALUE( MID( TEXT( DateTime_Field ), 15, 2 ) ), 60 ) <> 0
