All Collections
Basics
Date Range Filter
Date Range Filter
Patrick avatar
Written by Patrick
Updated over a week ago
  1. Click on the 'Filters' tab on the left panel once you've selected your block.

  2. Click 'Add Filter' and then click on the filter to edit the details:
    ​

  3. Select a field from your spreadsheet that contains a valid date
    ​

  4. See the new 'Date Range' filter appearing in the filter bar at the top of the block. Notice that I've filtered for August 1 - 3, and only orders from that range are appearing:
    ​


    ​

  5. Users will have a calendar popup to select the date for each of the two date pickers in the filter:

Important Tip:

When working with dates, make sure you've configured your Date Format in the Google Sheets settings before creating your block to ensure the most seamless experience and to ensure Frontly is able to parse your dates correctly.

Did this answer your question?