Can I use specific timestamp values in my predictive query filters?

To use specific timestamp values in your predictive query filters, insert the date and time values in ISO 8601 standard format (YYYY-DD-MM). 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

📘

NOTE: Date/time values should not be enclosed in quotes.