Alpha DevCon 2018
Results 1 to 3 of 3

Thread: How to search date field for all Marchs

  1. #1
    Member
    Real Name
    Michelle DiNardo
    Join Date
    Feb 2007
    Posts
    25

    Default How to search date field for all Marchs

    Does anyone know how I can search a date field for all "Marchs"?

  2. #2
    Member
    Real Name
    Charles A. Halsall
    Join Date
    Sep 2002
    Location
    Belmopan, Belize, Central America
    Posts
    55

    Default Re: How to search date field for all Marchs

    I'm surprise that this has not been answered yet. In your query screen, on the date field just enter */3/* or from the main menu search option MONTH(DATE)=3.

  3. #3
    Member
    Real Name
    Michelle DiNardo
    Join Date
    Feb 2007
    Posts
    25

    Default Re: How to search date field for all Marchs

    Thank you! I'm still working on this project and needed this info.

Similar Threads

  1. Search for Date only in Timestamp field
    By askoog66 in forum Application Server Version 11 - Web/Browser Applications
    Replies: 8
    Last Post: 02-26-2013, 01:21 PM
  2. Search Substring of Date field?
    By MoGrace in forum Alpha Five Version 8
    Replies: 3
    Last Post: 12-10-2011, 09:20 PM
  3. MySQL Search Date Field - Fails
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 6
    Last Post: 02-04-2011, 09:20 PM
  4. QBE Search Row - QBE date search field only allows 20 characters?
    By kingcarol in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 08-17-2010, 12:02 PM
  5. Default Date in Search Field
    By Rich Hartnett in forum Web Application Server v7
    Replies: 7
    Last Post: 07-14-2006, 07:38 AM

Posting Permissions

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