SharePoint Integration

Re: Date format and Sharepoint list

Brucacuda — Tue, 20 Apr 2010 18:14:53 GMT

I don't think infopathdev is allowing anyone to post images on the forums anymore because now they have it set to be hosted elsewhere. I suspect that's the reason they're gone from above now...

Re: Date format and Sharepoint list

redemption1 — Tue, 20 Apr 2010 17:04:57 GMT

The images seems to broken, is it possible to resend,

Regards,

Re: Date format and Sharepoint list

Brucacuda — Wed, 20 Jan 2010 19:04:18 GMT

I just wrote up a document over how to do this very thing when using current the date as part of the name of the document when it is submitted:

Normal looking date (01-15-2010) in a string:

concat(substring(now(), 6, 2), “-“, substring(now(), 9, 2), “-“, substring(now(), 1, 4))

In InfoPath, go to your Data Connection in the form
Use the Data Connection Wizard to go to the File Name and click the formula button then plug the formula above in red in

Re: Date format and Sharepoint list

Patrick Halstead — Wed, 02 Dec 2009 03:51:21 GMT

InfoPath uses XML data types which by default uses YYYY-MM-DD as the underlying representation. You are concatenating these values in a string on submit, so you will need to change the format before at that time. You could write code to do this or you could add a text field to your form and a rule action on submit that sets the value by concatenating substrings. Use the substring-after and substring-before commands with fixed length to extract the YYYY, MM, and DD from your date string and concanate in the format you want. Then, you can promote this field to SharePoint

Date format and Sharepoint list

michaelborup — Tue, 01 Dec 2009 14:12:55 GMT

In my Infopath form i have two date-fields in a repeating table. Its formatted like DD-MM-YYYY. But the view in my Sharepoint list after submitting the form, shows the dates like this: YYYY-MM-DD.

In properties for submitting, the date fields are concatenated.....

Any solution?

Thanks in advance.

/Michael