Requests Older than 6 Days

Fadem · 2022-06-08T14:15:27+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Beast Mode

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)

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 Works! Thank you!