Sunset at Oak Island, North Carolina

Spider Web Woman Designs

Working with Today's Date in the Microsoft FrontPage® Database Results Wizard

Queries in FrontPage can be run using today's date as your criteria, e.g. if you are creating a calendar, you may want to show only those events whose date is today or later.

In Access SQL, today's date is expressed as Date().

So, to show only those events whose date is today or greater, your SQL would look something like this:

"SELECT event,location,event_date,cost FROM calendar WHERE (event_date>=Date()); "


There are two ways to accomplish this in the FrontPage Database Wizard.

One way is to:

  1. Run the Wizard
  2. In Step 3 select More Options | Criteria | Add
  3. In the Add Criteria dialogue box, choose event_date as the Field Name
  4. Type "Date()" (without the quotes) in the Value field
  5. Finish the Wizard
  6. Switch to HTML view and find your SQL statement in the gray colored code
  7. Modify the SQL statement to look like the statement above
  8. Save your changes while still in HTML view
  9. Preview your page in your browser.

Add Criteria Dialog Box

The other way is to

  1. Open your database in Access
  2. Create the query
  3. Switch to SQL view
  4. Highlight and copy the SQL (this will place it on the Clipboard)
  5. Close the database
  6. Open FrontPage
  7. Open your query page
  8. Select Custom Query in Step 2
  9. Paste the SQL (contents of clipboard) into the custom query window
  10. Finish the Wizard.


Email UsWe're on Google+LinkedIn ProfileFollow us on TwitterLike Us on Facebook!