I’ve noticed an issue with the date display on the dashboard graphs. When I create a chart using the “day” value on the X-axis, the displayed date is D-1. For example, today’s date, September 5th, is shown as September 4th on the graph (see attached image).
thank you very much for the report and I am very happy to see what beautiful dashboards you have built for your team
We will definitely fix this issue! This is very likely to be a time zone issue, which happens to us every now and then with new features that perform date calculations or filters, as this area is unfortunately very complex. But with the help of our community we will get this definitely 100% bug free before we leave the beta phase.
We will get back to you here with the fix or if we need more information from you.
Thanks for bringing up your issue (and for sharing that sophisticated reporting dashboard - nice!).
After @Felix was luckily able to resolve this quickly, we just deployed a fix - indeed, the timezone was not properly applied to reports with daily grouping. Kindly confirm that this works properly now on your end @agnes.farias?
Thanks @Tim ! Dashboards are showing the correct date now.
Also thanks for the compliments regarding the appearance of my dashboards, I appreciate!! This new feature is helping my company a lot.
But in the same matter, my views grouped by date - more specifically by day - are also showing D-1. i.e.:
(Date format is DD/MM/YYYY).
The dates in this view are supposed to be 04/09, 16/09, 20/09 and 30/09.
Hi @agnes.farias ,
I just deployed a fix that should solve your observed timezone bug in the views.
Could you please confirm whether the issue is solved or still persists?
This is a calculated field that is supposed to display a date field from another app. But the displayed date is D-1 for some reason. This is the date field with the original date:
Oi Agnes!
Isso está relacionado com um bug que eu tive recentemente nos dashboards, pode ter relação com o fuso horário.
Entendo que é o mesmo assunto do tópico original, talvez um teste interessante é vc definir um horário no campo de data horiginal - por exemplo, 12:00, e ir mexendo nesses horários pra ver como o campo calculado se comporta.
This is still the timezone issue in my opinion.
We noticed it happening a lot in our implementations here in Brazil.
Pls Tape team, we can deal with no PT-BR language (even though it makes new clients hard to come) but this timezone issue for dates really messes up our data.
Could you share the script that you use for your calculation field?
When you refer to a date field token in a calculation field, and the date field value has no time, it will still yield a date (because the value is a JavaScript date) at 00:00 in UTC. You need to handle that case properly, as calculation fields have no timezones and will execute in UTC. The duality of date field values with and without time can be a little tricky to work with.
Olá, toni. Passei pelo bug nos dashboards e nas datas nas views que são agrupadas por data, e agora tive um problema com um cliente grande pois o campo que se refere a data estava mostrando D-1, que interferiu no gatilho de uma automação muito importante.
Agnes, então, o que acontece é que os campos de data no Tape remetem ao fuso horário UTC 00:00.
Como nosso fuso é UTC -03:00, é preciso considerar a atribuição do fuso horário sempre que trabalhar com Datas em campo calculado.
Aqui tem um comparativo entre 4 campos:
O primeiro é o campo editável.
O segundo é referência simples “@campo”
No terceiro só tem a formatação da data
No quarto é aplicado o fuso horário do Brasil - UTC-03:00