Date element dropdown filter issue [SOLVED]

[SymOn75]

Hi,
I use Fabrik from 3 years and I think it's fantastic!
Now I've an issue with my custum application that I've build with fabrik.
- Joomla 2.5.19
- Fabrik 3.0.9

I've a table with a date element that is a required filter in advanced search. Filter type is dropdown.
When I select a date, for example 02-04-2014 it show in table records of 02-04-2014 and 03-04-2014...
Why it show record of selected day and the next?
If I change filter type from dropdown in rage it works fine... (but I need it to be a dropdown).
Please help me....
Thanks

 

[troester]

What is your filter setting (exact=yes/no)?
You can enable fabrikdebug (in fabrik options, "Debug" tab), then append &fabrikdebug=1 (or - depending on your URL ?fabrikdebug=1) to your URL.
A click on "list GetData" will show you the generated query.

 

[SymOn75]

Hi troester, thanks for you reply.
My filter settings:
filter type: dropdown
exact match: yes
full word match: no (I think it's irrelevant in this case)
Required: yes (I need to be yes)
Include in advanced search: yes (I need to be yes).

I've activated fabrik debug and this is the generated query:
WHERE ( `perf_machinedaily`.`Production_date` BETWEEN '2013-10-24 00:00:00' AND '2013-10-25 03:59:59'

Why there's BETWEEN 2013-10-24... AND 2013-10-25 ???
I selected 2013-10-24 but the query is BETWEEN!
I need to show a dropdown filter that enable users to select a single day...

 

[SymOn75]

I've tried to install all in my local xampp and it works fine...
Why it dont works online on server web?

 

[SymOn75]

I've solved it!
The proble was generated for mistaked configuration of joomla.
In global configuration I've changed current server time from 'universal' to 'phoenix' because my shared server is near phoenix.