How can I create a custom moving date range

user14700
user14700 Member
in Magic ETL

I need to create a custom date range that moves with the current day. It needs to show the date range of the previous 10 days and the next 5 days based on current day. I can't seem to wrap my head around how to get started on it and if it can even be done in beast mode. 

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    So let's say the date column of your date is just called `Date`. 

     

    In that scenario you can build a beast mode that says:

    CASE WHEN `Date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 10 DAY) 
    AND `Date` <= DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY) 
    THEN 'Include' 
    ELSE 'Exclude' 
    END

    Then add that to your filters section of your card and set it to Include. That should give you only dates within the range you mentioned.

     

    Best of luck,
    Valiant

     

     

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    So let's say the date column of your date is just called `Date`. 

     

    In that scenario you can build a beast mode that says:

    CASE WHEN `Date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 10 DAY) 
    AND `Date` <= DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY) 
    THEN 'Include' 
    ELSE 'Exclude' 
    END

    Then add that to your filters section of your card and set it to Include. That should give you only dates within the range you mentioned.

     

    Best of luck,
    Valiant

     

     

Categories