Best answer by npace29
View original
Best answer by npace29
View originalHello,
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
If the above does not work, you may try the following instead:
RIGHT([ICViewFATranListReport.FinPeriodID],4) + '' + LEFT([ICViewFATranListReport.FinPeriodID],2))
Okay, Thank you. its working
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.