A quick way to insert the current date and time in an Excel spreadsheet, Access table, or SQL Server table is to use the following keyboard shortcuts:
- Current date: CTRL+SEMICOLON
- Current time: CTRL+SHIFT+ SEMICOLON
- Current date and time: CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON.