Requests Older than 6 Days

Fadem
Fadem Member
in Magic ETL

Hi Guys!

I am trying to capture dates that are older than 6 days, but this Beast Mode is showing me zero although I know I have some.

SUM(case when DATEDIFF(`Effective Time`,CURRENT_DATE()) >=6 then 1 else 0 end)

Thank you!!

Tagged:

Best Answer

  • Godiepi
    Godiepi Coach
    Answer ✓

    Hi @Fadem

    You need to change the order if using "greater than or equal to" 6

    like this

    SUM(case when DATEDIFF(CURRENT_DATE(),`Effective Time`) >=6 then 1 else 0 end)
    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Godiepi
    Godiepi Coach
    Answer ✓

    Hi @Fadem

    You need to change the order if using "greater than or equal to" 6

    like this

    SUM(case when DATEDIFF(CURRENT_DATE(),`Effective Time`) >=6 then 1 else 0 end)
    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Fadem
    Fadem Member

    @Godiepi Works! Thank you!

Categories