I would just like to know how Date fields are searched.
In order to do this, I want to know in what format should I search.
Do I search datetime as a timestamp? as a string?
ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It only takes a minute to sign up.
Sign up to join this communityWhen using the range filters, Low Search will transform a given date for a date field to a UNIX timestamp, using strtotime()
, unless an integer is given; then a timestamp is assumed.
Most dates in EE are stored as UNIX timestamps, which are accurate to the second. When you enter a date without a time, 00:00:00 is assumed as time (standard strtotime behaviour).
Low Search automatically detect the date field. You should search the date in the format of yyyy-mm-dd (like 2012-01-01).