We have a field value having some text like “Refreshed on {.RefreshDate}”.
Is there a way to force the formatting of the RefreshDate (stored as “20250123” (23th of Jan 2025)) as “23/01/2025”
In correspondence rules, you can add a formatting to the <p:r n=… tag. Is something similar possible in field value parameters?
@Joris Claus
no, Field Value text doesn’t support inline formatting like correspondence tags, it only substitutes {param/property} as-is. The fix is to pre-format before you call the field value. In your data transform or activity, build a parameter/property like Param.RefreshDateFormatted = @DateTime.FormatDateTime(@DateTime.ParseDateTime(Param.RefreshDate,“yyyyMMdd”),“dd/MM/yyyy”, tools). Then reference that in the field value, e.g., Refreshed on {Param.RefreshDateFormatted}. If the source is a property, consider a computed read-only property .RefreshDateFormatted set the same way via a declare expression. Alternatively, store the date as a proper Date/DateTime and let a pxDateTime control display it with a “dd/MM/yyyy” format in UI text, but still pass the formatted string into the field value. Avoid trying @{…} or <p:r …> inside a Field Value—they won’t evaluate there.