How do I filter between 2 timeframes in Magic ETL?

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?

Best Answer


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

    in a filter file with a formula criteria

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColemenWilson
    Answer ✓

    If I solved your problem, please select "yes" above

  • 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

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

    If I solved your problem, please select "yes" above