InfoPath Dev

 Hi

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

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

 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))

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

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

 Regards,

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...