SharePoint Integration

Re: DOB Concat in Infopath -> Sharepoint

Steven_Smith — Thu, 07 May 2015 12:36:32 GMT

It definitely needs the leading 0 for a date format type field. However, doing a little more experimentation and it seems that the concatination causes a problem as it converts the data to a text type which date won't accept. I haven't managed to convert it back to date successfully yet.

Re: DOB Concat in Infopath -> Sharepoint

wd40dev — Thu, 07 May 2015 12:30:54 GMT

The way i have entered the list in the infoapth drop downs is singular for 1-9 then carrying on 10+ in the same way for both day & month values.

Should the singular values be 01, 02, 03 etc etc?

Re: DOB Concat in Infopath -> Sharepoint

Steven_Smith — Thu, 07 May 2015 11:07:55 GMT

Are your day and month fields keeping (or adding) leading zeros if required? If the leading zero is dropped for the day or month then the field won't evaluate correctly.

Re: DOB Concat in Infopath -> Sharepoint

wd40dev — Thu, 07 May 2015 10:59:21 GMT

The value for month is numerical with the corresponding month 'name' as Display name. Year is in YYYY format.

I have been advised the format should be MM/DD/YYYY which is the method i have used in the submit formula

Re: DOB Concat in Infopath -> Sharepoint

Steven_Smith — Thu, 07 May 2015 10:46:59 GMT

You need to make sure that the date is the correct format, I am assuming it is all numbers and matches the format for date in SharePoint?

DOB Concat in Infopath -> Sharepoint

wd40dev — Thu, 07 May 2015 10:11:58 GMT

Good Morning All,

I have an infopath 2013 form, that has 3 drop down lists for DOB (Month/Day/Year).

On the submitt button of my form there is a 'Set a fields value' action:

Field: Age

Value: Age = concat(DOBMonth, "/", DOBDay, "/", DOBYear)

When i execute my initial form, with any date selections (from the drop downs), the field in Sharepoint returns a 'false' entry.

Any help on this would be greatly appreciated, am i missing something, is there a cardinal rule i should be following in regards to the drop down data itself?

Many Thanks