I’m trying to calculate the age of a contact record in days using an Architect expression, but the result keeps coming back as null. I have a timestamp stored in the contact.created_at variable and I want to compare it against the current date using DateTimeDiff. Here is the expression string I’m passing in the Data Action:
DateTimeDiff("${contact.created_at}", "${now}", "days")
I’ve verified that contact.created_at is a valid ISO 8601 string like 2023-10-01T12:00:00Z. The now variable is resolved correctly via a previous GetNow data action. I also tried using GetDayOfWeek on the same timestamp to rule out format issues, and that worked fine. But DateTimeDiff just fails silently with a null output.
Is there a specific format requirement for the second argument? I read somewhere that it might need to be a specific epoch format or that DateTimeDiff doesn’t support the now variable directly. I’m running this in a Genesys Cloud org with the latest platform version. The error log just says Expression evaluation failed: null without any stack trace. What am I missing here?