Error Table Filter date range

[black.be3]

Hi,
Please help..
I have filter from date element that set to range, date formated on dd-mm-yyyy.
But it seems that it not work properly because on fabrik debug i can see that it will search the same date only.
For example, if i put start:01-01-2012, end : 05-02-2012
On table:mergeJoinedData get ids query it will have
"BETWEEN '2012-01-01 00:00:00' AND '2012-01-01 23:59:59'"..
isn't it supposed to be '2012-01-01 00:00:00' AND '2012-05-03 23:59:59' ??
I use Joomla 1.7.5 & Fabrik latest Git on windows machine

 

[xtrgeo]

Have a look on this:

http://fabrikar.com/forums/showthread.php?t=24827

 

[cheesegrits]

OK, I think this should be fixed in github.

-- hugh

 

[black.be3]

sorry, still error..
the year always "2000"

if i put start:01-01-2012, end : 05-02-2012
On table:mergeJoinedData get ids query it will have
"BETWEEN '2000-01-01 00:00:00' AND '2000-02-05 23:59:59'"..

isn't it supposed to be '2012-01-01 00:00:00' AND '2012-02-05 23:59:59' ??

my date element formated on dd-mm-yyyy or on element setting -> %d-%m-%Y

if i user %Y-%m-%d, the filter works..

 

[black.be3]

Friendly bump

 

[troester]

There seem to be some issues with date filtering, I've opened an issue at GitHub
https://github.com/Fabrik/fabrik/issues?sort=updated&direction=desc&state=open&page=1

 

[xtrgeo]

I've added some comment on the issue u opened!

 

[xtrgeo]

somebody made changes on this at github i guess. I've added another comment on the issue there after the latest update...

 

[cheesegrits]

We're working on date filters at the moment, several commits over the last day or two.

We're still testing and fixing things, so keep the feedback coming.

-- hugh

 

[xtrgeo]

" just updated from github and noticed that it now works in a different way!Now the filtering is made like:
"Return all the the records that has their date element SMALLER or EQUAL THAN the SECOND date of the url" !!! "


still works this way..

 

[black.be3]

Is there any progress about this? I'm still having problem with date filter when date formated as %d-%m-%Y, is not working.

 

[cheesegrits]

Out of interest, are you typing the dates by hand, or using the date picker?

I've been testing this using the date picker, and haven't been able to replicate your problem. But just noticed that if I type the dates by hand, rather than using the date picker, things go a bit wobbly.

Working on it now.

-- hugh

 

[black.be3]

Both on %d-%m-%Y and %Y-%m-%d, i use date picker.

 

[cheesegrits]

I've just committed a couple of changes, which fix the typing vs using picker widget in date filters.

And at the moment, I can't replicate your issue. Date range filtering is working fine for me, with either of the formats you mentioned.

If they are still broken for you, I'll need to get at your page.

-- hugh

 

[black.be3]

Thank yo, so far it works