Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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