Need help with below query

#1

Hi,

I need help with below query-

if field(‘Status’) == “T-3” then date(“09/01/2014”) end

Trying to add Status condition like A-3, B-2 etc…
when tried && or || is not working… Any help appreciated…

#2

Try

case status when 'T-3' then date('09/01/2014') when 'A-3' then date('03/08/2014') when 'B-2' then date('02/10/2014')end

see https://www.mockaroo.com/b8f89760