Mapping XSD time field to SharePoint DateTime (format=timeonly)

Question

Hi,

I have got this Infopath time field which I'm trying to map with SharePoint DateTime field (Format=Timeonly). the form does get submitted to library but the SharePoint Time Field is empty and when I edit the sharePoint Time field in Edit Properties then it goes for exception (yellow screen).

SharePoint DateTime field is expecting yyyy-mm-ddT00:00:00 which it then converts to Time only and infopath is sending only Time which is causing this problem.

I did try to edit this field on form submit to submit yyyy-mm-ddT00:00:00 but like this form can not be submitted as it says time format is not correct.

 any idea??

Thanks in advance

Aqi

Answer 1

any help plese...

Answer 2

Hi ,

I understand that you want to map a time field to SharePoint DateTime field. How do you format the SharePoint DateTiem field to TimeOnly?

As far as I know, the Date and Time column can be formatted as Date only or Date &Time in OOTB way. Can you provide more information about formatting the DateTime field to time only? I assume that you are publishing the form to a form library and the DateTime field is a column in the form library.When publishing the form to form library ,you need to map the  DateTime Control to the DateTime field.

Select (This form library) in the Site Column Group and choose the DateTime column in the Column Name.Check ‘Allow users to edit data in this field by using datasheet or properties page’.

Thanks,

Entan Ming

---

Entan Ming

TechNet Community Support

Answer 3

Hi Entan,

Thanks for your reply.

>>>I understand that you want to map a time field to SharePoint DateTime field. How do you format the SharePoint DateTiem field to TimeOnly?

<Field ID="{A91FE5FE-4F45-4A4F-827B-5EE9246BC405}" Type="DateTime" Name="XYZTime" DisplayName="XYZ Time" Format="TimeOnly" Group="MDD" Node="//ctt:main/EndTime"></Field>

yes I'm submitting this form to SharePoint Library and wan to have saperate column for time.

many thanks for your help.

Regards

Aa

Answer 4

any help???