Year = current year

RajNadar · 2022-08-02T16:27:14+00:00

There was an error rendering this rich post.

If my booking year = system year then cy else py

not sure what was the error in beast mode..pls suggest

CASE

WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE(),"CY" ELSE "PY" END

Find more posts tagged with

Some minor tweaks to your beast mode:

CASE 
WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE()) THEN "CY"
ELSE "PY"
END

It would help to understand what format `Booking Year Nbr` is in.

CASE 
WHEN `Booking Year Nbr` = YEAR(CURDATE()) THEN 'CY' 
WHEN `Booking Year Nbr` = YEAR(CURDATE())-1 THEN 'PY' 
ELSE 'Other' 
END