You can adjust the timezone in most of our DATE and TIME functions.
Let me know if you want me to look at the specific Klip.
The DST link from Berkeley is 404
I have removed the second link as it appears to have moved or been deleted.
Thanks for drawing this to my attention.
The challenge here is that if we use the standard Klips with (today) as a call function it pulls from the EDT timezone even though my Google/Facebook etc is set to GMT+4. Does this basically mean I need to rewrite the code for each of the standard klips to add the timezone? there is no standard timezone setting in the general account settings?
We try to handle timezones to the best of our ability in any pre-built content you find in the Klip Gallery or Dashboard Gallery. Usually, this involves pulling your Google/Facebook account settings in via an API query, then using the result to offset any functions that are timezone-dependent (such as the TODAY() function). So, if your Google account is configured to be in GMT+4, we'll use that in the formulas when creating your Klip.
Currently, there is no general account setting that would allow you to specify timezone, but our product team has definitely discussed this before! I will add your vote to the feature :).
Hope that helps,
I'd really like to see Timezone as an option in the account settings. I'm in New Zealand and having to adjust now() and today() every time I use them is a pain. In fact, does it even work? I'm trying:
DATEVALUE(now("GMT+12"), "dd-MM-yyyy hh:mm a")
But no luck. :-(
Please prioritise this for your international clients!
Thank you for adding your voice to the community and raising your support for this request. I'll add you name to this feature request for additional context.
In the meantime, to help with your current example, the timezone is a parameter of the DATEVALUE function as opposed to a parameter of the NOW function. Please give this a try:
DATEVALUE((NOW()),"dd-MM-yyyy hh:mm a","GMT+12")