[Feature Request] Allow the DATESTR function to parse times for timezones other than UTC

We are in pacific time. When I create a formula column like this:

DATESTR({CreatedAt})

It switches to the next day at 5pm due to the 7 hour offset with UTC, this means that our buckets do not line up exactly with our actual workdays. Would it be possible to add an option to specify timezone when calling DATESTR?

It’s interesting because CreatedAt times display correctly for our timezone, its just when calling DATESTR on them that the day ends up incorrect for our timezone.

Hi @johnbalis
This is caused bc we use UTC while storing all dates and we show based on client timezone. When you convert it to string that conversion doesn’t happen.

I have created a proposal for this on repository which you can follow the progress.

1 Like

Cheers! Will follow with interest.

1 Like