Overview

To use specific timestamp values in your predictive query filters, insert the date and time values in ISO 8601 standard format (YYYY-MM-DD). Hours/minutes/seconds can also be included, but are assumed to be 0 if left out.

For example, the following predictive query excludes customers that have joined after 2022-01-01 12:45:30:

PREDICT COUNT(transactions.*, 0, 10)  
FOR EACH customers.customer_id  
WHERE customer.date_joined < 2022-01-01 12:45:30