Date Ranges

Problem

how to get a date range with extract special
trying to get a range of dates in MacNail construction accounting software while using the extract special command.

Diagnosis

1. unprotect document
2. change one of the other criteria headings to be 'date'
3. under the first 'date', type in >=3/1/95 or whatever
4. under the second 'date', type in <4/1/95 or whatever

Solution

if not getting items, make sure both are legitimate dates! If they use 2/29 when not a leap year, or 4/31, 6/31 etcetera, it won't find anything.
also check other criteria cells to make sure nothing is in them. Have user select each crieria cell and hit backspace/delete key.

HINT-- yet another place where Goldenseal accounting software is MUCH easier. The Find command lets you get a range of dates, or any other combination of matches.

Comments

Entered 4/4/95 by Dennis. Updated 11/8/2010.