Is someone able to help with my formula below? It's the second 'WHEN' that is the issue - instead of displaying Date Approved + 70, it's showing Date Approved + 50 and I am not sure why

CASE WHEN (TO_DATE({custbody_date_approved}) - TO_DATE({expectedreceiptdate})) < 51 THEN TO_DATE({custbody_date_approved}, 'DD/MM/YYYY') + 50  WHEN (TO_DATE({custbody_date_approved}, 'DD/MM/YYYY') - TO_DATE({expectedreceiptdate}, 'DD/MM/YYYY')) > 51 AND (TO_DATE({custbody_date_approved}, 'DD/MM/YYYY') - TO_DATE({expectedreceiptdate}, 'DD/MM/YYYY')) < 71 THEN TO_DATE({custbody_date_approved}, 'DD/MM/YYYY') + 70 ELSE NULL END

add another forumla column to your search with just TO_DATE({custbody_date_approved}) - TO_DATE({expectedreceiptdate}) in it, and look at the results again

I have that formula already - it's displaying 53