15
Views
2
Comments
Solved
[Data Grid Reactive] Using the Date Column is returning the wrong date
Forge component by Bruno Martinho
6
Published on 24 Feb 2021
Application Type
Reactive

Hello,

First, I'd like to congratulate on this new release. It brings really good features.

I am having a problem when using the Date Column.

On the Database it is date as well, but when I display the data it is showing one day behind. 

The screenshots I am using are from the example sample.



I am currently on Pacific Timezone (GMT-8). If I change my Timezone to UTC (GMT-0) or any other positive Timezone, it shows correctly.


So I am guessing the component, even though it is a Date column, is converting to Datetime. (The datetime column is working just fine).

Is it possible to have a fix for that?

Thank you.

Staff
Rank: #52
Solution

Hello @Joao Kuae 

A new version has been released - version 2.0.8

The problem that you have reported has been fixed if you update to this version.

Please let me know if this worked for you.

Bruno Martinho.

Champion
Rank: #248

Hi Joao,

This looks like a timezone issue. You can use this component to convert the date in desired timezone. For Example you can use below to convert the server date time to EST.

DateTimeToDate(ConvertFromUTC(CurrDateTime(),"Eastern Standard Time"))
mvp_badge
MVP
Rank: #10

Hi @Joao Kuae!

Thank your for reporting this situation, specially with all the details that you gave (it really helps!)

We'll analyze the problem and keep you posted.
Sorry for the inconvenience!

Best regards,

Rúben Gonçalves

Staff
Rank: #52
Solution

Hello @Joao Kuae 

A new version has been released - version 2.0.8

The problem that you have reported has been fixed if you update to this version.

Please let me know if this worked for you.

Bruno Martinho.