Microsoft KB Archive/32839

Works: Sorting by Month or Day in Date Field

PSS ID Number: Q32839 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 =

When data is entered in the Works Database in date format and the field is formatted as a date field, you can sort based on the entire date entered. However, you cannot sort only by month or day.

For example, if you have several entries for January, you cannot sort by month to have all the January dates appear together, followed by the February dates, and so on.

Workaround
To work around this situation, do the following:

  From the Edit menu, choose Insert Column to insert a field next to your date field. Name the field Month by choosing Name from the Edit menu.   In the Month field, enter the formula “=MONTH(Date)” (without the quotation marks), where “Date” is the name of the field containing the complete date (month, day, year). This formula returns only the month from the Date field. Note: In Works version 3.0, if the date field has the same name as a Works function, such as Date or Year, the field name inside of the function must be enclosed in single quotation marks, for example, =DAY(‘Date’). This is not necessary in earlier versions. 

You should now be able to sort on the Month field.

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.