Insert the Current Date/Time in a SQL Server, Excel Spreadsheet, or MSAccess

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.
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: