CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • using dates in search builder
Pages: [1]

Author Topic: using dates in search builder  (Read 896 times)

amb922

  • Guest
using dates in search builder
November 06, 2009, 10:21:11 am
I'm trying to a search with search builder using a date field.  I want to do a search that is essentially MembershipExpirationDate > mm/dd/yyyy.  What format is the query in search builder looking for?

Thanks.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: using dates in search builder
November 06, 2009, 04:00:16 pm
YYYYMMDD

No punctuation or quotes or anything
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • using dates in search builder

This forum was archived on 2017-11-26.