Skip to Navigation

Reply to comment

Certain field types use special values with a given comparison operator. For example, what if you wanted to query on a checkbox? How would you specify only those records with the checkbox checked?(Answer: {'fid'.EX.'0'} for unchecked, {'fid'.EX.'1'} for checked: you need to replace fid with your checkbox field id.)

These special Matching Values are not always obvious, so we put them in the following table:


Field Type

Matching Value






Used to filter records by the checked or unchecked status of the checkbox.
1 = Is checked
Example: {'17'.EX.'1'}

0 = Is unchecked
Example: {'17'.EX.'0'}

Date and Date/Time



<num> days ago


-<num> days ago



Filter records by a date criteria.

today = Todays date. Example:{'13'.EX.'today'}

Number of days in the past as measured by the current date. Example: {'13'.EX.'2 days ago'}

Number of days in the FUTURE as measured from the current date, with a negative sign in front of the number to denote the future-ness of the date. Example: for tomorrows date, {'13'.EX.'-1 days ago'}

A specific date. For example: {'13'.EX.'05-18-2008'}



Used to get records owned or created by the current user.

For example, {'20'.TV.'_curuser_'}


The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit