Thank you for the direction.
error →
ERROR: function pg_catalog.date_diff(“unknown”, timestamp with time zone, timestamp with time zone) does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts.
I ended up with this for now. I may need to revisit if timezone conversion is needed.
dateDiff(parseDate(toString({first_date}),“yyyy-MM-dd”),parseDate(toString({payment_date}), “yyyy-MM-dd”),“DD”)