how to capture the current quarter using beastmode

WorldWarHulk

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

RobSomers

You could do this:

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

RobSomers

You could do this:

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

WorldWarHulk

Hi Rob -

Thanks for this!!!