Displaying the correct Date format in a Drop Down box

renegadekn — Fri, 26 Sep 2014 17:26:52 GMT

I have created an InfoPath for using InfoPath 2013 and everything is working just the way I need it to except for one thing.

I have a drop down box that reference a date only field on a SharePoint list. However, when the user accesses the drop-down list more than the date is displayed which will become very confusing to them.

Instead of just displaying the date it displays YYYY-MM-DDT00:00:00. I tried using calculated field for the display drop-down and it made it look nicer removing the time but it broke the rest of the form because I have that date linked to all the other dates on the form to populate the other dates based on what the user chooses for the initial dropdown.

Ultimately I would like the drop-down to display MM-DD-YYYY without breaking the rest of the form.

General

Displaying the correct Date format in a Drop Down box