Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2004-10-28
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 14

Expert Comment

ID: 12440209
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

hhammash earned 200 total points
ID: 12440259

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

ID: 12443187
Ok.. ty... I will give that a try
LVL 14

Expert Comment

ID: 12445447
It will work

Author Comment

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

618 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