Joao Kuae
17Views
3Comments
Solved
[Data Grid Reactive] Using the Date Column is returning the wrong date
Question
DataGrid
Reactive
Forge
Data Grid Reactive
Forge component by Bruno Martinho
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.

1
0
on 16th Feb
Bruno Martinho
Staff
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.

See solution in context
1
0
on 24th Feb

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"))
0
2
on 16th Feb
Ruben Goncalves
mvp_badge
MVP

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

1
0
on 16th Feb
Bruno Martinho
Staff
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.

1
0
on 24th Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Post Closed