topic Re: Bug: FeatureTable displays null dates as 12/31/1969 in ArcGIS JavaScript Maps SDK Questions

Bug: FeatureTable displays null dates as 12/31/1969

JeffJacobson — Mon, 11 Jan 2016 21:17:47 GMT

The FeatureTable widget displays NULL date values as 12/31/1969 (i.e., 0 in Unix Time, adjusted for my local time zone).

Is there a workaround for this?

AkshayHarshe — Mon, 11 Jan 2016 21:27:30 GMT

Hi Jeff,

I believe they have fixed this bug in Server 10.3 and above. There are few things you might want to check.

1) your server version

2) Check if the field is set to not null-able.

3) If you have imported the date filed for older shapefile into database and published it to server.

If anything doesn't work then try using a string field instead of Date.

Thanks,

Akshay

JeffJacobson — Mon, 11 Jan 2016 22:19:56 GMT

The issue is on the client side. The map service is correctly returning null. It's the FeatureTable widget that is converting the null values to 1/1/1970 UTC.

AkshayHarshe — Tue, 12 Jan 2016 18:53:34 GMT

Jeff,

I see what you are saying.

I checked out featureTable API Reference and looks like there isn't anything to control the display if the date value is null-able.

There is something called dateOptions but there has to have a date to use that and format it.

Let me see what I can do.

Thanks,

Akshay

JeffJacobson — Tue, 12 Jan 2016 18:58:45 GMT

Thanks for looking into this.

SteveCole — Tue, 12 Jan 2016 19:12:59 GMT

FWIW, per this thread, Kelly Hutchins says that dateOptions was disabled but never responded when prompted on an update about the matter.