Hello, I need to format a datacard value to only accept the following time format, can I use IsMatch to do this, and if so, how do I go about it?
8:00 am - 5:00 pm
My users need to enter Hours of Operation for the resources we track. I am having issues making it recognize the colon, or the am/pm function. Also, it will need to be something that accepts a 12 hour clock so "##:## am/pm - ##:## am/pm" seems like it would work, but it doesn't.
Tom, thanks for responding. I believe it would be considered a string. Essentially the datacards will allow my co-workers and volunteers to enter information about resources, that will then be shared with clients. The data being entered requires the specific formatting for consistency. I can't have one person entering 9-5, while another enters10:30 am to 4:30 pm, and so on. Therefore I need to force their hands a bit and require specific formatting. I am just beginning the switch from Access, where input masks handled this, so I am a little lost. I have to do the same thing for my phone numbers, but this one is a little more complicated.
Also, I am not sure where to put this requirement, as replacing the Parent.Default in the Data section of the valuecard simply returned the response false once and then did nothing further.
Any help is appreciated as I learn this new program.