Date field inexplicably displaying time in Sharepoint form library

[orangepanda]

Long-time lurker, first time poster.

I have a form being utilized as a basic service request form. It is
submitting data to both SQL and a Sharepoint form library. For all of
the date fields, the date is necessary, however the time is not (date
fields are for due dates, expected date of completion etc. and only the
date is needed). I have set the field in Infopath to display the date
only (e.g. 2/4/2006) and submit only this data to SQL and Sharepoint.
When I view the data submitted to SQL, the date is being recorded as I
intend (e.g. 2/4/2006). When I open the form via the Sharepoint form
library, the date is being displayed as I intend (e.g. 2/4/2006). The
problem is in the display if the form library where I have asked that
the "Estimated Date of Completion" be shown. This is being displayed as
"2/4/2006 12:00 AM" This is misleading and will indeed cause confusion
in that it is much to specific than necessary. If anyone has run into
this issue, I would love to hear how you handled it.

 

[Adam Harding]

Orange Panda

Had the same problem with a set of forms my colleague and I were designing.
What you are seeing is the XML value for the field because the form library
formatting has not been set to only show date and not time.

SQL Shows it the way Infopath Submits it
The form opening from sharepoint uses Infopath formatting
BUT the Sharepoint site does not know how to display the data from the
database and so displays it natively as XML

Hope this helps.

Adam