Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

QuickBooks Search and wildcards overview

The following information offers examples specific to using wildcards in date and other searches.

Note: If you do not enter any information in the search field, the results will return blank.

General examples:

Note: The default search pattern is John*. Searches are not case-sensitive; that is, the result of searching for John, john, and JOHNwill be the same.

  • California John searches for california AND john (AND is added by default)
  • California or John searches for california OR john
  • California | John searches for california OR john
  • California and John searches for california AND john
  • California & John searches for california AND john
  • 990304 "California John" searches for 990304 AND california john (expression within quotes is searched as is)
  • 990304 "California or John" searches for 990304 AND california or john (the word “or” within quotes is not treated as a keyword)
  • John or California Intuit searches for john OR california AND intuit

Wildcard examples:

  • California John* searches for California AND john* (all words begining with John)
  • California *John Searches for California AND *John (all words ending with John)
  • California *John* Searches for California AND *John* (all words ending or beginning with John)
  • California Jo*hn Searches for California AND Jo*hn (* within a word is not interpreted )
  • California "John*" Searches for California AND John* (quotes prevent * from being interpreted as wildcard)
  • California John*** Same as California John*
  • California ****John***> Same as California *John*

Date Examples:

Note: User-given date fields can be separated by a space, hyphen (-), or slash (/)

  • 3 5 2010 searches for date: March 5 2010
  • 352010 searches for 352010 (treated as a number, not a date)
  • 17 dec 2010 searches for date: Dec 17 2010
  • 5/6/2010 searches for date: May 6, 2010
  • 17-dec-2010 searches for date: Dec 17 2010
  • december 4 2010 searches for date: Dec 04 2010
  • dec 4 searches for date: Dec 04 2010 (uses current year if year is not specified and a date pattern is found)
  • 05/06 searches for date: May 6, 2010 (uses current year if year is not specified and a date pattern is found)
  • "Palo Alto" Mar 5 2010 searches for: alo altoAND date: Mar 5 2010
  • "Palo Alto" "05/06" searches for Palo Alto AND 05/06 (due to quotes, 05/06 is not treated as a date)
  • 7 may 99 searches for date: May 7 1999 (20th century 4-digit year used due to presence of 99)
  • 7 may 10 searches for date May 7 2010 (21th century 4-digit year is used)
  • 7 may 00 searches for May 7 2000 (year 2000 is used)
  • 7 may 04 searches for May 7 2004 (year 2004 is used)
  • 7 may 4 searches for May 7 2010 AND 4 (yYear has to be a 2- or 4-digit number. A number like 4 cannot be treated as a year)
  • 7 may 10 4 searches for May 7 2010 AND 4

 

KB ID# INF12882
12/9/2016 6:58:35 PM
QYPPRDQBKSWS08 9138 Pro 2017 7c0a3d