Database Results by Date

[Crush]

We are using a spreadsheet as the data source for a data
results page. All efforts to limit the results by date
have failed. What we would like is for it to display just
from this day forward, as the past is of no consequence.
Normally in Access, >=Date() would do the trick. Any
ideas?

 

[Jim Buyens]

-----Original Message-----

We are using a spreadsheet as the data source for a data
results page. All efforts to limit the results by date
have failed. What we would like is for it to display just
from this day forward, as the past is of no consequence.
Normally in Access, >=Date() would do the trick. Any
ideas?

Excel makes a lousy database. If possible, you should
export the application to Access or some other database.

If that's not possible, you might have better luck adding
a column to your database range which is 1 or 0 depending
on whether the date is current or past. Then, filter on
that column.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Crush]

Never mind, I got it. I rule.

 

[Crush]

Normally that is very true. But this spreadsheet actually
serves many purposes offline as well. For those purposes,
a vacation calendar, a database wouldn't work quite as
well.