Forum Discussion

Qrew Assistant Captain

6 years ago

Date on a grid edit report while in edit mode shows 1547942400000 for 1/20/2019

In a grid edit report, I have a date field coming from a lookup table (where the date field is the primary key). It shows 1-20-2019 correctly when I click on the drop down arrow. Once I select it, and...

Qrew Elite

Dates are internally represented as the number of milliseconds since that start of the Unix Epoch - midnight on January 1, 1970. This behavior is probably related to making the [Date] field the primary key. Choose another primary key and the behavior you observe will probably go away.

SuryaExpert

Qrew Assistant Captain

6 years ago

Dan, It is true that it is the seconds from 1/1/1970. However, it is not related to making the date the primary key. I used to have this issue even when it is an ordinary field in RoR application. When you pull a date value using the QB API, it always gives this result for date fields. Then I used to convert it back to a date to show it on the screen for the user. But in plain quickbase, I wish QuickBase takes care of this. As they pointed out, it is a bug and I urge QB to fix that bug soon.