Microsoft KB Archive/49993

Works: Querying for Today’s Date with the NOW Function

PSS ID Number: Q49993 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

To search for today’s date using the NOW function in a database query, use the following formula:

=INT(NOW)

The NOW function returns a number indicating today’s date, with a decimal value indicating the current time. You must embed the NOW function within an INT function to truncate the resulting value to an integer. This allows Microsoft Works for MS-DOS to query the value against existing date field entries.

Additional information on the NOW function is contained on page 246 of the “Microsoft Works Reference” for version 1.05, on page 332 of the “Microsoft Works Reference” for version 2.0, and page 27 of Appendix A of the “Microsoft User’s Guide” for Works 3.0.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.