Works: Entering Current Date/Time in a Database or Spreadsheet (79224)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works 4.5
- Microsoft Works 4.5a
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q79224 SUMMARY
The current date and/or time can be entered into a Works for Windows
Database or Spreadsheet by using the following keystrokes:
|
| Current date | CTRL+SEMICOLON | | Current time | CTRL+SHIFT+SEMICOLON |
The NOW function in Microsoft Works for Windows allows you to have the current date and/or time display in a database field. The formula to enter this data is:
The fields would need to be formatted in an appropriate date and time format. Every time the database is opened, the system date and time will be entered in every record. To time stamp a record with the current date or time, use the current date or time entry.
These entries will not change when the database is opened. Enter this data using the keystrokes noted above.
MORE INFORMATION
If the NOW function is entered as a formula in a field, you can override this with another valid date or time entry. When a field is entered in a new record, the fields that have a formula with the NOW function are filled with the current system date or time. Go to that field and press the appropriate current-date or current-time key combination. That information will not be changed upon opening the file at a later time. Any record that did not have the entry for the date or time applied in the key combination method is updated.
For more information about how to perform these tasks in Works, see your
Works printed documentation or online Help.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbinfo KB79224 |
|---|
|