[Data Grid Reactive] Using the Date Column is returning the wrong date

Joao Kuae

Rank: #1645

Solved

[Data Grid Reactive] Using the Date Column is returning the wrong date

Question

DataGrid

Reactive

Forge

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.

on 16th Feb

Bruno Martinho

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.

See solution in context

8 days ago

Ravi Vakkalanka

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"))

on 16th Feb

Ruben Goncalves

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

on 16th Feb

Bruno Martinho

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.

8 days ago

Training

Documentation

[Data Grid Reactive] Using the Date Column is returning the wrong date