Can someone tell me where I am going wrong please?

sobo · February 21

CASE
WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())
WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW())-1,'-',YEAR(NOW()))
WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1)
ELSE ''
END

MarkSnodgrass · February 21

I think you could make this easier by using the DATE_FORMAT() function along with DATE_SUB().

CURRENT MONTH

DATE_FORMAT(NOW(),'%M %Y')

Would return February 2024

PREV MONTH

DATE_FORMAT(DATE_SUB(NOW(), interval 1 month),'%M %Y')

Would return January 2024

CUR MONTH PREV YEAR

DATE_FORMAT(DATE_SUB(NOW(), interval 1 year),'%M %Y')

Would return January 2023

sobo · February 21

This helped! Thank you

GrantSmith · February 21

Without having more information about what your issue is I'm assuming it's dealing with your prev month where it's subtracting a month.

You want to make sure you subtract a month from your date before getting the month and year for it.

CASE
WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())
WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW() - INTERVAL 1 MONTH),'-',YEAR(NOW()-INTERVAL 1 MONTH))
WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1)
ELSE ''
END

sobo · February 21

I have a beast mode, 'metric', in this case that essentially has the current month, previous month and this month previous year stored in it. 'Metric' is a beast mode I created using a date column. My objective in this beast mode is to essentially change the name from current month to the name of the actually month and what year.

For instance right now curr month should return February 2024 and prev month should return January 2024. I want this to be dynamic.

The solution you sent didn't work for some reason

MarkSnodgrass · February 21