https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79891.aspxWed, 27 Jun 2012 17:10:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79891Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/79891.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=79891<p>You could add another column to your SharePoint list with the date in the format you&#39;d prefer, and use that column for the Display for your drop down, the other for the Value.</p> <p>Or you could use substring functions in your default value to put the date back together - <a href="http://www.infopathdev.com/files/folders/examples/entry41104.aspx">here&#39;s</a> a sample form that has some different Date formulas that might help you.</p>https://www.infopathdev.com:443/forums/thread/79773.aspxFri, 22 Jun 2012 00:16:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79773carlos_fb800https://www.infopathdev.com:443/forums/thread/79773.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=79773<p>I created a form&nbsp;with a drop down menu that uses a data connection to a Sharepoint&nbsp;library&nbsp;to select the starting date of all weeks on 2012. However, I have to adjust the values in the list to YYYY-MM-DD in order to make a formula I added to the day fields to automatically calculate each day&#39;s date. I know this is the only format XML supports to store the data but I&#39;d like to know if there&#39;s a way to display the data in MM-DD-YYYY format on the drop down field without breaking the formula; or is there any other formula that I can use to get this to work?</p><p><img src="http://i47.tinypic.com/ctj89.png" border="0" alt="" /></p>