I have a model written with the query editor, and I'm trying to add a custom field like
convertTimezone([Start], [Regions → timezone])
where [Start] is a date field and Regions -> timezone contains a timezone.
This gives me an Invalid expression expression error. It works if I use an explicit timezone like "UTC".
Does anyone have any idea on why this is failing?
If I'm not able to make this work, is there a way to convert a model definition to a SQL query, so that I can easily add my column there?
TonyC
2
I think you're after this feature request:
1 Like