Try using the lookup table transform to keep a map of user locations and the timezone offset. When calculating the end date, do a lookup in your table using the location attribute of the account to get the timezone offset. You can use the value of the timezone offset in your expression when calculating the end date in their local time.
1 Like