Expand my Community achievements bar.

How to enter a valid Edit Pattern for Time?

Avatar

Former Community Member
I'm tring to enter a pattern for the Edit Pattern and it kept giving me the invalid pattern error.



Here is what I have for the Display Pattern: h:MM A

And for Edit Pattern: h|hh|h:MM|h A|hh A|h:MM A|hh:MM A



The textbox is set to Type: Date/Time Field.



Help is appreciated.
1 Reply

Avatar

Former Community Member
ljcharlie@hotmail.com wrote:

> I'm tring to enter a pattern for the Edit Pattern and it kept giving me the invalid pattern error.

>

> Here is what I have for the Display Pattern: h:MM A

> And for Edit Pattern: h|hh|h:MM|h A|hh A|h:MM A|hh:MM A

>

> The textbox is set to Type: Date/Time Field.

>

> Help is appreciated.



The last two are the only valid edit patterns. All of the others are invalid. Here are the reasons:

- You have to specify the minutes

- If not using military hours (H, HH) you have to specify AM or PM



The only way to support the other patterns you are trying to use is to make it a text field and put

custom javascript validation on it.



--

Justin Klei

Cardinal Solutions Group

www.cardinalsolutions.com