[look_b4u_leap]

Hiya!

This is probably super easy, I just can't seem to figure out how to do it.

I have a Date/Time field in a table, which is in "Short Time" format. I want people to only be able to enter times in increments of 30 minutes.

Is there some way to put in a validation rule to "only allow times that have a 'minutes' value of '00' or '30'"?

Many thanks!

[OBP]

This can be doen using VBA in the Field's After Update Event Procedure.
This works for a Filed called "Hours"
Dim min As String
minutes = Right((Format(Me.Hours, "hh:mm")), 2)
If minutes <> "30" And minutes <> "00" Then
MsgBox "minutes must be either 30 or 00"
Me.Hours = ""
End If

[look_b4u_leap]

Thanks for the quick reply! I forgot to mention, I need it without using VBA. And please don't ask why haha, I'm tired of explaining why I can't use VBA. thanks!

[OBP]

The time/date is stored as a number, it is only the format that makes it 00 or 30 so put this in the Validation Rule
Right((Format([Hours],"hh:mm")),2)="00" Or Right((Format([Hours],"hh:mm")),2)="30"

[look_b4u_leap]

Except that it needs to be in Time/Date format.

Okay I guess I need to be more clear.... haha sorry.

These are musts:

-the field is in Time/Date format
-users can only enter times in increments of 30 minutes
-not a drop-down list - users need to be able to enter the time by typing it into the table directly
- No VBA/SQL: needs to be set up right in the table design window

Many thanks!

[OBP]

The answer I provided does what you want, I have tested it.

[Stacers]

I think this will do exactly what you need:

Minute([NameOfYourField])=0 Or Minute([NameOfYourField])=30

[look_b4u_leap]

Many thanks!