How to create an All Values for a Date Field in Drop-Down using DB results

Posted on 2004-10-28
Last Modified: 2013-12-24
I know how to create an all Values selection in my dropdown for a text field. I was wondering how I would do this for a drop down that is a date field. I have Frontpage 2003.

Thanks for your help/direction in advance...
Question by:cam2003
    LVL 14

    Expert Comment

    What I do is but "All" option then the value between 01/01/1700 and 01/01/2050.  All years between 1700 and 2050 will be listed.

    Unless date field is a text field  you can put %

    LVL 14

    Accepted Solution


    Put this code in the SQL box of Frontpage to do the trick:

    SELECT * FROM Orders WHERE (OrderDate  between #01/01/1800# and  #01/01/2050#)

    Step 1- Select the Database
    Step 2- Select the Record source then click the edit button and add the above code "similar to if of course to suite your needs"
    Continue the DRW normally as  you know.

    Here I am selecting all orders between year 1800 and year 2050. The idea to includes all dates between two dates that are far before the first date and far after the last date to be on the safe side and include all dates in the drop down.


    Author Comment

    Ok.. ty... I will give that a try
    LVL 14

    Expert Comment

    It will work

    Author Comment

    My apologies.. I couldn't get back to you.. Some stuff happened here.. and I couldn't try it ... Thank you for the help

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
    The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now