Case when and formula with date

EChampagne

I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong?

case

when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0

ELSE `Total referrals`

end

Note, my date shows as the little calendar and 'Total referrals' column is "abc" format.

GrantSmith

On your top condition you are returning `Total referrals `=0. If you want it to be 0 in this condition then just return 0

case 

when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then 0 

ELSE `Total referrals`

end

GrantSmith

On your top condition you are returning `Total referrals `=0. If you want it to be 0 in this condition then just return 0

case 

when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then 0 

ELSE `Total referrals`

end