Searching by date range

Results 1 to 2 of 2

Thread: Searching by date range

  1. #1
    Jamie Silvia Guest

    Default Searching by date range

    I&#039m creating a bulletin board that has a Search page. On that page I want to include a selection criteria so that the user can select to view all the bulletins that were posted within a specific date range that they would choose from a FROM DATE and TO DATE field. When a user first creates a bulletin, they select a Post Date (the date they actually want the bulletin to be posted). So basically, I&#039m a little confised on how to implement this on my Search Page so that I can have a user select that they want to see all the bulletins that were posted between an earlier "Post Date" (FROM) and a later "Post Date" (To). Any help or direction is greatly appreciated!<BR><BR>jsilvia@amica.com

  2. #2
    Arvind. Guest

    Default RE: Searching by date range

    &nbsp;<BR> Hi<BR><BR> Use dynamic query for eg..<BR><BR> select * from table where fromdate &#062;= &#060;form.fromdate&#062;<BR> and todate &#060;= &#060;form.todate&#062;<BR><BR> i hope this will help you<BR><BR>Arvind.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •