CalcDate is the new field name, and the DateSerial function creates a date when given a numeric year, month, and day. In the second column of the grid, enter CalcDate: DateSerial(2018,1,) to create a calculated field. Type in the new name and press Enter.Ĭreate a new query based on the importOrders table. Since we will eventually append more months to this table, rename the table to “importOrders.” To do this, right-click on the name in the navigation pane and choose Rename from the shortcut menu. Add a field called “DateOrder” with a data type of Date/Time. The original worksheet only included a column (Dy) indicating on which day of the month an order was placed. Last month, we imported the first month of data from an Excel workbook into a table called “importJan.” Before importing additional months from the Excel workbook, we need to update the January records so they have an actual order date.
0 kommentar(er)
