Newbie Questions

Re: Validating Date Picker with submit button

jwilliams — Mon, 10 Jun 2013 15:24:52 GMT

It worked!!!! Thank you!!

Re: Validating Date Picker with submit button

Hilary Stoupa — Mon, 10 Jun 2013 15:08:23 GMT

The date separator is a "-", not a "/". Yes, that is what I'm suggesting you change is the date pattern, if the field is a date type. :)

Re: Validating Date Picker with submit button

jwilliams — Mon, 10 Jun 2013 14:49:28 GMT

Ok, I tried both custom patterns, \d{4}/\d{1,2}/\d{1,2} and \d{1,2}/\d{1,2}/\d{4}. They both are not working. Is that what you were suggesting I change, or? I really appreciate your help thus far.

Re: Validating Date Picker with submit button

Hilary Stoupa — Mon, 10 Jun 2013 14:42:38 GMT

But the thing is - your custom pattern is not going to be comparing to the way the date is formatted, but to the actual value of the date field, which will be yyyy-MM-dd.

Re: Validating Date Picker with submit button

jwilliams — Fri, 07 Jun 2013 13:54:36 GMT

I looked at the date formatting and it was already set to 1/12/2013. My options for date format is non (display xml value) which is not what it is set to. and display the date like this: and it has already been set to 3/14/2001 format. Thanks for the response. any other suggestions?

Re: Validating Date Picker with submit button

Hilary Stoupa — Thu, 06 Jun 2013 14:14:49 GMT

The XML date format is:

yyyy-MM-dd

So, that is what your date picker is storing. You can change the format on the field that displays the date, if the field is a date data type. The data will be stored as 2013-01-12, but you can set the control to display 1/12/2013 - does that make sense? You can either look at a saved XML file in a text editor to see this, or add a calc'd value bound to the field and formatted to show the XML value to help you see what is going on.

Separating data from presentation is something InfoPath is very good at, but it can make things like this confusing.

Re: Validating Date Picker with submit button

jwilliams — Thu, 06 Jun 2013 13:36:11 GMT

Does anyone else have any thoughts on this problem? I still can't figure it out.

Re: Validating Date Picker with submit button

jwilliams — Wed, 05 Jun 2013 13:22:59 GMT

Thanks for the response. Not exactly sure what you mean here. I also have multiple text boxes on the form and have the respective button hide or appear when they are all filled in. If I take the date validation part out, the buttons do what they are supposed to do. It is just when I try and add the date validation that the buttons don't behave.

Re: Validating Date Picker with submit button

wilkies0106aw — Wed, 05 Jun 2013 06:26:08 GMT

I think you'll have to have your buttons in 2 sections and each section has a rule on it to hide when it condition is not met. InfoPath is just built the way it is built. That does allow you to be creative in your solutions.

InfoPath is used in SharePoint, you'd think at least the two teams would have talked to each other, but they didn't. Same with SharePoint and the Outlook teams.

Validating Date Picker with submit button

jwilliams — Tue, 04 Jun 2013 17:00:44 GMT

I have a button with a condition that references the Date Picker field "Date picker" ->matches pattern -> custom pattern -> (\d{1,2})/(\d{1,2})/(\d{4}) I want the button to disappear if the string entered is matched with the custom pattern. Then I have another button that I want to appear if it does match the custom pattern. I have tried to change the date picker box to string and date formats and both do not work. Irrelevant, but why does InfoPath not have built in date patterns? Any help appreciated, I have no idea why it is not working.