Create a field for dates and times

See Also

1. Open the table in Design View

2. Select the Fields tab

3. To insert a field within the table, click in the row below where you want to add the field, and then select Insert from the Field menu, or right-click on the field and select Insert
To add a field at the end of the table, select Add from the Field menu, or right-click in the fields grid and select Add

4. In the Name column enter the name of the field

5. In the Type column click the arrow and select DATE, DATETIME, TIMESTAMP, TIME or YEAR
For more information on MySQL field types, click