Date Operations Dialog Box

You can access the Date Operations dialog box in the following ways:
  • 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.
Option Description
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.