InfoPath Dev

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

How have you got Sharepoint TimeOnly field?

I manage to find only Date or Date and Time (but not TimeOnly) types of Sharepoint fields

Hi Gennaday, Thanks for your reply. if you create list from schema (pragmatically) then you have this option while creating Fields and you can specify the Format. Regards

Hi Gennaday,

this is how I have created DateTime field in SharePoint Library Schema.

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

Thanks

Aqi

anyone out there to help?? Plz

aqibarain:

Hi Gennaday,

this is how I have created DateTime field in SharePoint Library Schema.

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

Thanks

Aqi

 

Hi, Aqi,
this is irrelevant what you create in sharepoint as soon as you use Infopath field promotion:
promoting either creates from the scratch new field in sharepoint library with matching type or uses previous matching type

Now, if you insert in Infopath Designer 2010:

• Date Picker, then it does not have Time only choice in "Data type:" properties
• Date and Time Picker, then eliminate Date part on design surface, then the second Time part is converted into Text box control
• Text Box and choose Time in choices of "Data type:", then promote it, it is shown correctly in sharepoint library field entered through Infopath values like 23:59:00 but they cannot be edited in sharepoint

 Note that

• when changing the promoted fields you should remove and add then add them again into promoted list of Property Promotion (in Publishing Wizard or in Form Options)
• I do not see anywhere in sharepoint time the seconds, be it built-in or custom columns, they are just cut off
  

Hi Mate,

Thanks very much for your reply. what you are talking about is publishing from from INfopath directly to sharepoint library. I'm deoploying through WSP and infopath form is attached to a content type. That is why I'm mapping each field with infopath XSD.

Aqib