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