how to capture the current quarter using beastmode

WorldWarHulk Member

August 2022 in Magic ETL

Hi Domo Masters -

so, when we want to capture the current date what we do is

we use>>>

Case When 'Date'=Curdate() then 'True' else 'False' end

is there a way we can capture the current quarter?

Thanks!!!

0

Best Answer

• 

  RobSomers Coach

  August 2022 Answer ✓

  You could do this:

  case when QUARTER('Date')=QUARTER(Curdate()) and YEAR('Date')=YEAR(Curdate()) then 'True' else 'False' end

  **Was this post helpful? Click Agree or Like below**

  **Did this solve your problem? Accept it as a solution!**

  4

Answers

• 

  RobSomers Coach

  August 2022 Answer ✓

  You could do this:

  case when QUARTER('Date')=QUARTER(Curdate()) and YEAR('Date')=YEAR(Curdate()) then 'True' else 'False' end

  **Was this post helpful? Click Agree or Like below**

  **Did this solve your problem? Accept it as a solution!**

  4
• 

  WorldWarHulk Member

  August 2022 edited August 2022

  Hi Rob -

  
  

  Thanks for this!!!

  0