Trying to filter interactions older than 3 days using DateTimeDiff(GetNow(), GetInteractionStartTime(), ‘d’). The result is always NaN. Tried switching to ‘h’ and ‘m’ but same issue.
Checked the data types in the debug log. Both return valid ISO strings. Is there a specific format required for GetNow()?
Also tried GetDayOfWeek() just to test date functions and that works fine. Stuck on the diff calculation.