Best answer by npace29
View originalOkay, Thank you. its working
If the above does not work, you may try the following instead:
RIGHT([ICViewFATranListReport.FinPeriodID],4) + '' + LEFT([ICViewFATranListReport.FinPeriodID],2))
Hello,
You may try using the following formula in the Joins / Relations or conditions of the report.
LEFT([ICViewFATranListReport.FinPeriodID],4) + '' + RIGHT([ICViewFATranListReport.FinPeriodID],2))
Nigel
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.