Shortcut to Insert Time/Date in Excel or Access
Use the following shortcut keys to insert the current time and date in a Microsoft Access table or Excel worksheet.
(Current date: Press Ctrl + ; (semicolon)
(Current time: Press Ctrl+Shift+ ; (semicolon)
Note: When you insert the date and time using this tip, the information remains static. To update this information automatically, you must use the TODAY and NOW functions.
#TipOfTheWeek