⚠️ V1 Documentation: This article reflects Frontly’s previous builder. While most of the concepts still apply in the latest version, the screenshots and step-by-step instructions may differ from what you see in the current builder.
Click on the 'Filters' tab on the left panel once you've selected your block.
Click 'Add Filter' and then click on the filter to edit the details:
Select a field from your spreadsheet that contains a valid date
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:
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.