I want to show Formula(Date) field empty when there is no matching condition using CASE WHEN in the ELSE part, -> CASE WHEN {applyinglinktype} = 'Payment' THEN {applyingtransaction.trandate} ELSE '' END as shows I'm using '' to show nothing but it is giving error, please suggest!

There was another similar question the other day. use

ELSE NULL

great thanks! that works!

The reason being that all return paths in the

CASE

statement need to be the same datatype (

DATE

in your case).

''

is a string 🙂