Subfield Clauses

Timestamp fields possess date/time subfields that can be used in equality clauses. A subfield is accessed using “dot” notation and an upper-case mnemonic. Each subfield is an integer value and can be compared to an integer constant. Only equality (=) comparisons are allowed for subfields. Examples:

ReceiptDate.MONTH = 2 // month = February, any year

SendDate.DAY = 15 // day-of-month is the 15th

NOT SendDate.HOUR = 12 // hour other than 12 (noon)

The recognized subfields of a timestamp field and their possible range values are:

•	YEAR: any integer

•	MONTH: 1 to 12

•	DAY: 1 to 31

•	HOUR: 0 to 23

•	MINUTE: 0 to 59

•	SECOND: 0 to 59

Though timestamp fields will store sub-second precision, there are no subfields that allow querying the sub-second portion of specific values.