Microsoft KB Archive/61447

Works: Using the Current Date and Time

PSS ID Number: Q61447 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

The NOW function returns the current date and time in the Works Spreadsheet or Database. This function can be used in combination with the DATE(Year,Month,Day) function to calculate time passed since a certain event. For example, to calculate the number of days since December 29, 1965, use the following Spreadsheet formula:

=NOW-DATE(65,12,29)

More Information on the DATE function can be found on Page 233 of the Works version 1.05 manual and on Page 322 of the Works version 2.00 manual. Information on the NOW function is contained on Page 246 of the Works version 1.05 manual and on Page 332 of the Works version 2.00 manual.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.