How do I filter between 2 timeframes in Magic ETL?

Options
Mwatson
Mwatson Member
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

Answers

  • GrantSmith
    GrantSmith Coach
    Options

    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
    ColemenWilson Coach
    Answer ✓
    Options
    Screen Shot 2023-10-17 at 2.31.01 PM.png

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

  • ColemenWilson
    ColemenWilson Coach
    Options

    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.

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

Categories