Date filtering

Tags: #<Tag:0x00007efc602897f0>
#1

I saw another forum topic (https://jsfiddle.net/zgjponfc/) that talked about different conditions for filtering date columns, it mentioned ‘date_before’ I’m assuming there is also ‘date_after’. What about if I want to filter between 2 dates? Also sidenote, the tutorial doesn’t seem to have been updated to include the date conditions yet.

#2

Hi @christine

You could extend the previous condition by the adding similar code snippet but with date_after - hot.getPlugin('filters').addCondition(0, 'date_after', ['1/1/2015'], 'conjunction');

Here is an updated demo - https://jsfiddle.net/d87hxpuf/

It seems that we really don’t mention these possibilities - https://handsontable.com/docs/7.4.2/Filters.html

I’ll create an issue on our docs repo.

#3

Hi Piotr,

Thanks for that. Could you please also explain how to use the ‘between’ filter condition, and in not for dates?? How do I pass the 2 values ??

Cheers
Christine

#4

Here is a demo - https://jsfiddle.net/a4gr5h0f/ - with the condition 'between 2 to 24’ in the second column.

#5

Hi @christine

how’s the progress? Have you managed to get this working?

#6

I believe that we can close this topic as there are no new comments within 2 weeks. However, if you need anything please send me an email to support@handsontable.com

#7