I am developing a form used to manage information about visitors to our facility. I am collecting date and time of the visit, but for various reasons I want to keep these as separate fields.
My problem is this: For some reason, when uploading the form to my SharePoint library, the format of the time field doesn't come over correctly. Right now, instead of showing "12:00 pm" it's showing "12:00:00-04:00". I have run into this problem before and the fix (which I figured out after lots of painful online research) had something to do with doing the initial SharePoint publish using a text field and then changing it to a time format field and doing the "quick publish". I've fixed this before, but I'm having a heck of a time trying to fix it now.
My previous research indicated this was not uncommon. Anyone know a definite fix??