Forum Discussion

SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 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...
App builders
Grid edit
Relationships
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
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.