General

Re: Date formatting problem

NorrieF — Tue, 19 Feb 2013 09:16:14 GMT

Hi Patrick,

Thanks a lot for your response. The date picker is already formatting as a date.

Re: Date formatting problem

Patrick Halstead — Tue, 19 Feb 2013 01:05:00 GMT

Just right click the date picker control in the view and change formatting to date.

Date formatting problem

NorrieF — Mon, 18 Feb 2013 16:40:27 GMT

Hi I'm new to InfoPath and hoping I might find help here. I have a form connecting to a SharePoint list. I have a Date Field called Collection Date which is set to Date only in SharePoint. I was trying to get the Date Picker control in InfoPath to default to yesterday. When I use addDays(today(), -1), I get the red dotted lines around the field if I try to submit the form. I also tried to concatenate T00:00:00+00 onto the date concat(addDays(today(), -1),"T00:00:00+00) but no joy with that either. I'd really appreciate some help with this. Thanks.