Hi Ramon,Thanks for the response. What if the field type is text? The
data is being queried from a custom ACS Table and is being sent from
PEGA. It's also an eVar field and plans are to apply the function
through an enrichment activity.I tried using the the Ceil but received
the error belowPGS-220000 PostgreSQL error: ERROR: operator does not
exist: character varying / integer LINE 1: ...alia/Canberra' AS date),
Ceil(C1.sAddressPostcode / 1000) * ... ^ HINT: No operator matches the
given name an...