Why is CASE function always returning ELSE statement?

Robin Vanhoegaerden

Within our Case function we are comparing a number of months with "Timestampdiff" function with a descriptive flexfield that has numbers. We added the "Timestampdiff" function as a separate column in our analysis and did the same for the dff and both return numeric values. Our code is looking as follows:

CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_MONTH, "Job Application - Legislative Information"."Regulatory Response Date of Birth", CURRENT_DATE)/12 AS Int) > CAST( "Job Requisition - Additional Details"."IRC_REQUISITIONS_DFF_D_MAXAGE_" AS Int) THEN '0' ELSE '1' END