A CONCAT() expression combining a date field and a string in Report Designer doesn't print anything.

All FAQ questions / Reporting and analytics

Answer

Convert the date field to a string first with formatDateTime() before concatenating it — CONCAT() combined directly with a raw date-typed field can silently fail to print, while concatenating the same value after explicit date-to-string formatting works as expected.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions