It is possible to do a query sort by date in the database. An example would be
to find all students born between June 21,1985 and July 24,1985. To do this the
following formula would be used in the Database Query-
>DATE(85,6,21)#AND#FIELDNAME<DATE(85,7,24)
Insert your own field name for FIELDNAME.
This formula can be used for invoice dates, sales dates, ect. Just make sure to
put the dates in the same format in the query as in the Field Format for the
field in the database.
NOTE: Apple Computer Inc. is not responsible for the contents of this
article.