Filter Formula - Current Date + 3 days

Options
Simon_Hall_
Simon_Hall_ Member
in Magic ETL

I am running some automated production reports through the Shopify connector. Part of the data set is tags on the different lines items, which includes the date selected for pickup. I need the formula to essentially look in the 'tags' column for the Current Date of the report + 3 days.

I thought something like this would work: 'tags' = DATEADD(DAY, 3, TODAY()) but unfortnately not.

Any assistance would be great.

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In order to add 3 days to the current date you would want to write it like this:

    DATE_ADD(CURRENT_DATE(), interval 3 day)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In order to add 3 days to the current date you would want to write it like this:

    DATE_ADD(CURRENT_DATE(), interval 3 day)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Simon_Hall_
    Simon_Hall_ Member

    Thank you! Works perfectly.

Categories