Skip to Content
0
Former Member
Feb 24, 2012 at 11:25 PM

FMS Concatenation - Internal Error

154 Views

Hello Experts,

Can anyone help me with this FMS? I get Internal Error when i click on the formatted search but when i run this in SQL syntax it executes successfully.

SELECT 'Batch'= 
CASE When $[$3.U_SES_TrnsTyp.0]='Receipt' 
Then
(RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
+$[$3.U_SES_Code.0]+$[$3.U_SES_Lseq.0]+'('+$[$3.U_SES_Crg.0]+')')
When $[$3.U_SES_TrnsTyp.0]='Production' 
RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
Else ''
End