Date Operations

Ribbon bar. Select the Data tab. In the Transformations group, click Date/Time to display the Data Operations dialog box.

Classic menus. On the Data menu, select Date Operations to display the Data Operations dialog box.

This dialog box contains two tabs: Numeric Dates and Text Dates.

OK. Click the OK button to perform the specified action.

Cancel. Click the Cancel button to close this dialog box. Any changes made will be disregarded.