Usage of Keywords with ServiceNow Lookup Queries

When creating a new Lookup Query, the Query Builder options are a little different when the server type is ServiceNow.  The Keywords available in this case are described in the table below:

Keyword	Meaning
MINUTESAGO(INTEGER)	Used for comparison with date-time fields. e.g. [date-time field] < MINUTESAGO(30) would return all records where the date-time field was more than 30 minutes earlier than the current time.
HOURSAGO(INTEGER)	Used for comparison with date-time fields. e.g. [date-time field] < HOURSAGO(12) would return all records where the date-time field was more than 12 hours earlier than the current time.
TRUE	Logical TRUE condition for comparison with boolean fields.
FALSE	Logical FALSE condition for comparison with boolean fields.
YEARSAGO(INTEGER)	Used for comparison with date fields. e.g. [date field] < YEARSAGO(5) would return all records where the date field was more than 5 years earlier than the current date.
MONTHSAGO(INTEGER)	Used for comparison with date fields. e.g. [date field] < MONTHSAGO(6) would return all records where the date field was more than 6 months earlier than the current date.
NULL	Logical NULL condition
DATE	Equates to the current DATE
TIMESTAMP	Equates to the current TIME
DAYSAGO(INTEGER)	Used for comparison with date fields. e.g. [date field] < DAYSAGO(7) would return all records where the date field was more than 7 days earlier than the current date.
USER	Equates to the userid of the ServiceNow target connection;
USER_SYS_ID	Equates to the SysID of the user for the ServiceNow target connection;

In this case, the Lookup Query Current Entry Value is based on the target result set, (i.e. the value the target field will have once it has been updated).  For this reason, only target fields that have been mapped may be used in the query.

Note that the arithmetic functions, +, -, * and / as well as the logical operators NOT and LIKE are not allowed in this case (they can only be used with BMC Remedy servers).

Example Target Lookup Query for ServiceNow target instance: