if statement problems

[#1]

if(left([Referral_Date], 2) = '01'), Referral_Date as Date2,

Can someone tell me what is wrong with this if statement? I keep getting this error... "Error in expression:If takes 2-3 parameters" Thanks

[IAMDV · Accepted solution]

Try this...

IF( Left([Referral_Date], 2) = '01', Referral_Date, '') AS Date2

I had highlighted else bit in red color.. so that you can replace whatever you wanted.

Cheers - DV