InfoPath Dev

I am trying to populate a text box with a date value from a secondary data source connected to SQL Server. The date shows up with a time value that I do not want to display. How can I make only the date display without the time?
TIA
Dean

Hi,

Steps to display date only without the time:
1. Double click text box to see the properties of it, in which you want to dispaly only date with out time.
2. Under the Data tab click on "Format" button.
3. In the date and time format dialog box select the "(Do not diaplay time)" option under "display the time like this" division click ok two times to close the dialog boxes.

Hope this, it will solve your problem.

Thanks, but I have already done these steps. The text box displays the date correctly when I enter it or use the Calendar control, but when the text box gets filled from the Rule associated with a Dropdown list the time is shown. I think that I probably need to do some type of conversion in the xPath formula, but I don't know how.

I discovered that if I change the data type from Date (date) to Text (String) that the minutes do not get displayed.

Set the value in text box using rules to extract only the date after selecting date from date picker using below function
substring-before(datefield, "T").