How do I filter between 2 timeframes in Magic ETL?

Mwatson · 2023-10-17T20:27:42+00:00

There was an error rendering this rich post.

Hey Team! I am trying to filter a dataflow to just show the sales that we had from 10/12/2023 - Current. What filter formula can I use to accomplish this?

Find more posts tagged with

Accepted answers

ColemenWilson

Screen Shot 2023-10-17 at 2.31.01 PM.png

All comments

GrantSmith

Date BETWEEN DATE('2023-10-12') AND TODAY()

in a filter file with a formula criteria

ColemenWilson

Also, as @GrantSmith pointed out, if you have sales in the future then you would also need to include TODAY() or CURRENT_DATE() or CURDATE() in the formula to prevent records into the future from being included.

Additionally, on the card you choose date ranges for the data displayed and generally they are:
-Year to date
-Month to date
-Quarter to date
-etc…

Applying these ranges would prevent future records from being shown on the card.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of