FrontPage DRW and searching by date....

Posted on 2006-03-24
Last Modified: 2013-12-24
Ok I have an MS Access DB with a field called "DATE" marked as data type "Date/Time"

Now lets say I want to setup a search with Front Page to search for specific months, or specific years. Like for example return results only in March, or only in April etc?

Question by:jfs9900
    LVL 14

    Expert Comment


    First of all you can't name the field as Date, it is a reserved word,  it will create problems later.

    It depends how are you entering the month or the year?  are you using the Date/Time field to type today's date like:


    Lets say you want to view results by March?  only results during 03?

    The esiest way it to search for 03/01/2006 to 03/31/2006  this is to specify March 2006,  or 01/01/2004 to 12/31/2004 to specify year 2004.

    In your search form you should put two search fields
    - Field 1 name it as stdate
    - Field 2 name it as endate

    Create a DRW and create a statement that searches Between.

    Save the DRW
    Post the form to the DRW


    Author Comment

    The offical name of the feild is "TIMESTAMP"

    When I do what is listed above I get the following error:

    Database Results Error
    Description: Data type mismatch in criteria expression.
    Number: -2147217913 (0x80040E07)
    Source: Microsoft JET Database Engine
    LVL 14

    Accepted Solution


    Timestamp field is the problem.

    I usually create two fields on my own 1 for date and 1 for time I don't rely on the TimeStamp field that is created by Frontpgae.


    Featured Post

    Javascript: Crash Course

    Javascript is not only emerging as the most important language to know, it's flexibility is unique. With Javascript being deployed on the web, mobile and even the desktop this is the one language that all technologists need to know.

    Join & Write a Comment

    When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
    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 Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Click on Too…
    The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now