Filter data using date range picker

[Priya_Sharma]

Hello everyone,

I need to filter data using date range picker so the user can view data between start date and end date.

I'm using between condition but don't know how to use start date and end date from date range picker.

[Hyperbytes]

Old video but may help.

Using the date range picker

This 3m 30s video continues from the (Using the date picker to select a single date) video and demonstrates the date range picker. [date range picker]

[brad]

Select your date picker and then go to Dynamic Attributes -> Date Picker where you can se your min and max dates.

[Priya_Sharma]

Thanks for the quick reply @Hyperbytes & @brad. It was quick and very easy to apply filter. I don’t know how I missed it. Anyway for other users I’m posting the quick guide here. probably it’s my 1st tutorial I’m posting in community.

Q. Suppose, We’ve a table of 1M+ users. There is a date field in which we store the date of entry (account creation date).

How can we load data of users created from 01-Aug-2022 to 22-Nov-2024

Note: this is not full guide, it’s only for those who know how to add filters in query.

Answer:

1. Create start and end variables in $_GET

2. In Conditions tab > create a filter condition like this. (select account creation date)

3. Now add a date range picker in front-end UI.

<input id="dateRange" name="dateRange" is="dmx-date-range-picker" class="form-control form-control-sm w-25 me-2" placeholder="Select date range" dmx-bind:maxdate="varDate.datetime" dmx-bind:mindate="varDate.datetime.addYears(-1)" format="MMM Do, YYYY" opens="left" autoapply="true">

4. Now you have to select start & end date from date range picker input.

5. Select these