Hi All

I have a FnL template with a "Time" datacolumn.  If I enter "10:10 AM" into the field, the record can be saved ok.

If I add the following simple regex validation:

^((([0]?[1-9]|1[0-2])(:|\.)[0-5][0-9]((:|\.)[0-5][0-9])?( )?(AM|am|aM|Am|PM|pm|pM|Pm))|(([0]?[0-9]|1[0-9]|2[0-3])(:|\.)[0-5][0-9]((:|\.)[0-5][0-9])?))$

That same time value cannot be saved.   This is odd, this Regex will happily recognise "10:10 AM" and FnL will save ok using that value.

Why won't FnL save when a valid Regex is used to validate the time field ???? Am I doing something daft or is this a bug.  Has anyone got a Regex expression that they have used sucessfully in a FnL "Time" column.

Cheers - Guy  

Thanks Stefan,

that makes sense but our users do seem to struggle with getting the format right.  Is it possible to make the UI for the time datatype, a bit more user friendly, maybe Hr & Min drop downs ????

Cheers - Guy