Requests Older than 6 Days

Fadem

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!!

Godiepi

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)

Godiepi

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)

Fadem

@Godiepi Works! Thank you!