In the Display the date like this list in the Date and Time Format dialog box, click (Do not display date). In the Display the time like this list, click (Do not display time).Дouble-click the date picker, text box, or expression box control in your form template that you want to use to display the time. In the Display the date like this list in the Date and Time Format dialog box, click the display style that you want. Use the following procedure to display the date and time in separate controls:Дisplay the date and time in separate controlsД«efore you begin, make sure that your form template contains two controls, and that both controls are bound to the same field in the data source.Дouble-click the date picker, text box, or expression box control that you want to use to display the date.Д®nsure that the Data type list displays the Date and Time data type, and then click Format. To change the locale date and time settings, select the country or region that you want in the Locale list.Д«rowser-compatible form templates do not support the display of the date and time in the same control. Note:В Display styles that have an asterisk will be updated to reflect the current format specified by the user's system settings. To format the control to show both the date and time, select the display style that you want for the date in the Display the date like this list, and then select the display style that you want for the time in the Display the time like this list. To format the control to show the time only, select the display style that you want in the Display the time like this list. To format the control to show the date only, select the display style that you want in the Display the date like this list.

In the Data type Format dialog box, do one of the following: this post from Rich is very helpful and visual. If you are working with an expression box control, click the General tab.ДЇor a text box control or a date picker control, ensure that the Data type list displays the appropriate data type, and then click Format.ДЇor an expression box control, ensure that the Format as list displays the appropriate data type, and then click Format. Excel 2010 > Developer tabe > Insert > ActiveX bottom right > More > MIcrosoft Date and Time Picker (SP4). If you are working with a text box control or a date picker control, click the Data tab. In the Control Properties dialog box, do one of the following: To display the date and time in two separate controls, refer to the procedure 'Display the date and time in separate controls' at the end of this procedure.Дouble-click the date picker, text box, or expression box control whose data you want to format. Browser-compatible form templates do not support the display of the date and time in the same control. When a browser-compatible form template is published to a server running InfoPath Forms Services, and then browser-enabled, forms based on the form template can be viewed in a Web browser. Note:В When you design a form template in InfoPath, you can choose a specific compatibility mode to design a browser-compatible form template.

Microsoft date and time picker excel