ClarisWorks: Auto-entering Today‘s Date

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
ClarisWorks 2.0 supports auto-entered date fields as well as many other automatic entry options.

ClarisWorks 1.0 does not support auto-entered date fields, but you can auto-enter today's date into a calculation field. The formula for the calculation field is just the NOW( ) function. The calculation field should be set to result in a date. The NOW ( ) function is not updated when the file is opened on a later date, so the date entered will not change.

Alternatively, you can auto-enter today's date and display it as a formatted date. Define a calculation field (to result in Text) with this formula:

TodayDate (Calculation, Text result) = DATETOTEXT(NOW(),x)

where x= 0,1, 2, 3 or 4 (date format choice) format the date as per the following:

0= 2/23/91
1= Feb 23, 1991
2= February 23,1991
3= Sat, Feb 23,1991
4= Saturday, February 23, 1991

However, there are a few considerations...
1. This field will contain a text value that cannot be sorted like a normal date field.
2. This text value cannot be used in other date calculations because it really is text.
3. You cannot match records using this in a date calculation.
4. These values will not have any particular range, so there is no less or more than this field.
Published Date: Feb 18, 2012