Beastmode Between Specific Dates

sdarmody Member

October 2018 in Magic ETL

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

0

Best Answer

• 

  Godzilla Contributor

  October 2018 Answer ✓

  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)

  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'

  3

Answers

• 

  Godzilla Contributor

  October 2018 Answer ✓

  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)

  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'

  3
• 

  sdarmody Member

  October 2018

  Worked, thank you!

  0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In