Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My if statement is as follows:
IF(ISNULL(A),'No Receive Date',IF(B<>'Accepted',IF(LEN(C)>0,IF( LEN([D)>0, IF(D>C,'Delayed','On Time'),IF(NOW()-C<0,'On Time','Delayed')),'No Due Date'),'No Action')) as DELAYED
I am looking out for other options instead of using IF statement .
Please suggest me.
Why don't you try to put the condition at SQL level
There you would have more tuning options.
I am getting data from share point not database.
Thank you all