Beastmode Between Specific Dates

How can I write a beastmode to return data between two dates? For example

CASE WHEN 'Date' >= 10/01/2016 and <= 09/30/2017 then 'value' else 0 end

Thanks!

Sarah

Find more posts tagged with

try this:

CASE WHEN `Date` >= '10/01/2016' and `Date` <= '09/30/2017' then `value` else 0 end

I noticed you had single quotes around the field names. the field names should have the ` character(on the same button as tilda)

try this:

CASE WHEN `Date` >= '10/01/2016' and `Date` <= '09/30/2017' then `value` else 0 end

I noticed you had single quotes around the field names. the field names should have the ` character(on the same button as tilda)

Worked, thank you!