Date range is not working

[GMSadmin]

Hi forum users!

I am building a user report that searches for specific clients established within a certain period of time. (e.g. April 1st, 2012, - June 3rd , 2012). To do so, I have created a form that contains two drop downs, generated as two criteria attached to a data field that tracks when clients were established.

Unfortunately, I am not getting the results I expected, the query pulls an entire list of clients every time I search.

If anyone had experienced the same issue, or has any idea what I might be doing wrong, I would highly appreciate the help.

Notes: I have both fields "comparison type" set to Equal, and Group settings to AND.

GMSadmin

[HongTaiLang]

The Comparison type should be "Greater Than or Equal" Date from field and "Less Than or Equal" Date To field.

Check this http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/search-and-filter-comparison-types.html

[GMSadmin]

Thank you very much! All works now.

[PotatoMato]

Hi! You may check this article regarding date range using criteria: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/

[Kronos]

Hi everyone, just to add to this thread:

Comparison Types in Report DataPages

Hope this helps!

[cheonsa]

Hi all!

Sharing these articles for searching data between two dates:

https://howto.caspio.com/tech-tips-and-articles/range-search-finding-data-between-two-numbers-or-dates/