Silly question but.. how do I get minimum val...

(Greg Bounds) #1

Silly question but… how do I get minimum values to work for time column types? I have tried every combination of standard, military, etc… but the min / max seem to have no constraint on the field input.

(Aleksi Alkio) #2

Would you open this question little more… for example “minimum values to work”?

(Greg Bounds) #3

oh sorry @Aleksi_Alkio, let me elaborate.

So I want to lock down the time field input to 8am to 8pm, but the minimum and maximum time values don’t seem to have any effect. I’ve tried 8:00:00 and 20:00:00 and 8:00:00 AM versus PM, but I can put any time in (e.g. 3am). I suppose I could just use valid_if but thought it would be easy to use these fields.

(Aleksi Alkio) #4

I’m afraid you can’t use min & max options for time value. You need to create that feature with the validation rule.

(Greg Bounds) #5

@Aleksi_Alkio Fair enough, I wonder why they are there then… Thanks!