Searching in a date

Date type target fields only accept one format: YYYY-MM-DD

(Y for year, M for month and D for day).

List of search examples on dates:

“order date” = 2018	*> Valid: in 2018*
“order date” <= 2018-01	*> Valid: in January 2018 and before*
“order date” = 15/01	*> Error*
“order date” <= 2018-01-15	*> Valid: on 15 January 2018 and before***
“order date” <= 2018-01	*> Valid: in January 2018 and before*

Hours and minutes are not searchable in the quick search.

PLEASE NOTE

The !=, IN and NOT IN targeting operators are not used on dates.
Preset periods are not searchable in the quick search.

Related articles: