SharePoint Integration

Re: Datetime in SharePoint Form Library

ek38 — Mon, 06 Mar 2006 17:17:46 GMT

We (Colette) found an easier way than adding or modifying styles. Hopefully there are not any negative implications.

The Infopath date/time field is still published to SharePoint. However, we create another column in SharePoint. We can assign the new SharePoint Column to the value of the Infopath date/time field.

On the SharePoint column, we specify the option that says "Date" only.

Then in the particluar "View" we show the SharePoint column instead of the actual Infopath Column. Magically the column only shows the date and NOT the time...our desired results

Re: Datetime in SharePoint Form Library

AndersR — Mon, 27 Feb 2006 20:03:29 GMT

No matter what you select, you will always get both date and time since the field is a date object -you only select how to format a given date.

In SharePoint formatting is done by styles (check "modify settings..." > Views > Styles

If the styles in the list doesnt fill your requirements, here is a guide on how to add your own:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_SP2003_ta/html/ODC_WSSAddingCustomViewStyle.asp

hth

Datetime in SharePoint Form Library

ek38 — Mon, 27 Feb 2006 14:45:19 GMT

Our form is being published to SharePoint. We pick several columns to display in the SharePoint Form Library so users can sort, filter etc.

One of the fields is a "Date" field. We specify in Infopath to only use the date and NOT the time, but when it publishes to SharePoint, the column value in SharePoint had both DATE and TIME. (Time is defaulted to 12:00 AM.

We don't want the time to show up in the SharePoint Column. What can we do?

E