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

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.

0 4 359
4 REPLIES 4

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

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.

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

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

Top Labels in this Space