InfoPath Dev

Hi,

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.

The field is set as date field. I am getting the value as "2001-01-04T00:00:00", but i want to show only the date and that to in the dd/mm/yyyy or mm/dd/yyyy format.

How to format the date field, which is displayed in the textbox.

Thank you

Does your form recognize the field as a DateTime datatype?  If so, you should be able to use the TextBox property dialog to specify the format that you want.