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/63468.aspxMon, 24 Jan 2011 15:01:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63468Jimmy0https://www.infopathdev.com:443/forums/thread/63468.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=63468<p>Does your form recognize the field as a DateTime datatype?&nbsp; If so, you should be able to use the TextBox property dialog to specify the format that you want.</p>https://www.infopathdev.com:443/forums/thread/63465.aspxMon, 24 Jan 2011 14:25:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63465venkatzeus0https://www.infopathdev.com:443/forums/thread/63465.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=63465<p>Hi,</p> <p>I am using Infopath 2010 filler form. I am retrieving data from sql server 2008 database using secondary dataconnection and setting it to a field in the form. </p> <p>The field is set as date field. I am getting the value as &quot;<font size="2">2001-01-04T00:00:00&quot;, but i want to show only the date and that to in the dd/mm/yyyy or mm/dd/yyyy&nbsp;format.</font></p> <p>How to format the date field, which is displayed in the textbox.</p> <p>Thank you</p> <p><font size="2">&nbsp;</p></font>