SuryaExpert
6 years agoQrew Assistant Captain
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 tab to the next column in the grid, it shows the number 154794240000. When I save the report and it shows the data again, there it shows the date correctly as 1-20-2019.
What am I missing? How can I make sure it shows the date correctly all the time and not as the long numeric field.
What am I missing? How can I make sure it shows the date correctly all the time and not as the long numeric field.