topic Re: Default date of 1970 for date field at 2.3 in ArcGIS JavaScript Maps SDK Questions

Default date of 1970 for date field at 2.3

MarkSmith — Thu, 09 Jun 2011 07:22:23 GMT

Hello,

I have a date field in my layer with no default value defined in the database. Users then use an API with the editor and attribute inspector to create features and populate the attributes - normal stuff.

At 2.2 when the user creates a shape, the attribute inspector pops up and the date field is empty. If they click the field the date picker appears conveniently on today's date. This is the behaviour I want and expect.

Now at 2.3 when the attribute inspector opens after adding a new shape, there is a date already in the date field of 01/01/1970. It's not just me either, the Validate Attribute sample does the same thing: http://help.arcgis.com/en/webapi/javascript/arcgis/demos/ed/ed_attributeInspectorValidate.html

Can anyone please tell me how to fix this?

Re: Default date of 1970 for date field at 2.3

TonyContreras — Thu, 09 Jun 2011 15:54:41 GMT

Here is a site that explains the default date.

Javascript Epoch

Re: Default date of 1970 for date field at 2.3

ReneeMaxwell — Thu, 09 Jun 2011 17:46:27 GMT

I have the same question. The link posted above is not helpful at all. How is it possible to override this default behavior with the attribute inspector?

I don't think it's reasonable to expect users to click 41 times from 1970 to 2011 just to set a date.

Re: Default date of 1970 for date field at 2.3

HemingZhu — Thu, 09 Jun 2011 19:10:23 GMT

I have the same question. The link posted above is not helpful at all. How is it possible to override this default behavior with the attribute inspector?

I don't think it's reasonable to expect users to click 41 times from 1970 to 2011 just to set a date.

I was also perplexed by why it is changed from 2.2 for no good reasons. I have tried to overwrit this by the following code without success. Can ESRI or anyone enlight me on this?

code added on http://help.arcgis.com/en/webapi/javascript/arcgis/demos/ed/ed_attributeInspectorValidate.html
....
var myDateDijit = new dijit.form.DateTextBox({
                //regExp: "/^(1[0-2]|0?[1-9])\/(3[01]|[12]\d|0?[1-9])\/(\d{2,4})$/",
                required: false,
                promptMessage: "Enter a date",
                invalidMessage: "Enter valid date",
                //constraints: { min: dojo.date.locale.format(new Date(), { datePattern: 'MM/dd/yyyy', selector: 'date' }) },
                value: "" //defalut value
            });
.....

var layerInfos = [{
                'featureLayer': featureLayer,
                'showAttachments': false,
                'showDeleteButton': false,
                'fieldInfos': [
            { 'fieldName': 'name', 'label': 'Name' },
            { 'fieldName': 'email', 'label': 'Email' },
            { 'fieldName': 'phone', 'label': 'Phone', 'customField': myDijit },
            { 'fieldName': 'note', 'label': 'Details', 'stringFieldOption': esri.dijit.AttributeInspector.STRING_FIELD_OPTION_TEXTAREA },
            { 'fieldName': 'notedate', 'label': 'Date', 'customField': myDateDijit }
          ]
}];
....

Re: Default date of 1970 for date field at 2.3

KellyHutchins — Sat, 11 Dec 2021 21:19:51 GMT

The attribute inspector date calendar displays the date stored in the feature's date field. New fields don't have a value so the default date of January 1, 1970 is displayed. You can modify this by setting the date's value to the current date (or whatever value you'd like) when a new feature is created. To do this listen for the feature layer's 'onBeforeApplyEdits' event and update the date for the newly added feature(s). In the sample below 'pointsOfInterest' is the feature layer whose date field you want to update.

        dojo.connect(pointsOfInterest,"onBeforeApplyEdits",function(adds,updates,deletes){
          //update the date field for new features to be today's date.
            dojo.forEach(adds,function(add){
              add.attributes.notedate = new Date().getTime();
            });
        });

Re: Default date of 1970 for date field at 2.3

HemingZhu — Sat, 11 Dec 2021 21:19:54 GMT

The attribute inspector date calendar displays the date stored in the feature's date field. New fields don't have a value so the default date of January 1, 1970 is displayed. You can modify this by setting the date's value to the current date (or whatever value you'd like) when a new feature is created. To do this listen for the feature layer's 'onBeforeApplyEdits' event and update the date for the newly added feature(s). In the sample below 'pointsOfInterest' is the feature layer whose date field you want to update.
        dojo.connect(pointsOfInterest,"onBeforeApplyEdits",function(adds,updates,deletes){
          //update the date field for new features to be today's date.
            dojo.forEach(adds,function(add){
              add.attributes.notedate = new Date().getTime();
            });
        });

What a smart solution i miss! thanks Kelly!!

Re: Default date of 1970 for date field at 2.3

ReneeMaxwell — Mon, 13 Jun 2011 14:14:49 GMT

Kelly, that solution may be fine for newly created features. However, it doesn't address the problem for existing features. The attribute inspector displays attributes for existing features as well, and now any date field that has not been populated displays as 1-1-1970, even if it is null. This is confusing and misleading to users who might not realize how databases operate, but are simply querying a feature.

Not all date fields require a value for every record, so it would be nice if we could solve this problem without having to force edits that are not relevant or accurate in every case.

As others have mentioned, the default behavior of this dijit changed after the release of 2.3. We clearly liked it better before.

Re: Default date of 1970 for date field at 2.3

MarkSmith — Tue, 14 Jun 2011 06:52:52 GMT

Thank you Renee, I'd like to echo your comments. The date field worked just fine at 2.2, this is definitely a backwards step at 2.3. If anyone has a code solution for this I'd be grateful to see it, but in the meantime we're sticking with 2.2 for our editing APIs.

Thanks,

Mark.

Re: Default date of 1970 for date field at 2.3

HemingZhu — Tue, 14 Jun 2011 14:56:36 GMT

Thank you Renee, I'd like to echo your comments. The date field worked just fine at 2.2, this is definitely a backwards step at 2.3. If anyone has a code solution for this I'd be grateful to see it, but in the meantime we're sticking with 2.2 for our editing APIs.

Thanks,

Mark.

I agree with Mark. ESRI should look into this issue. At the same time, Except for the Kelly's suggestion, i found a workaround for edit feature for my purpose. Here is the code:

dojo.connect(pointsOfInterest, "onSelectionComplete", function(features) {

                dojo.forEach(features, function(feature) {
                    if (feature.attributes.notedate==null)
                    {
                        feature.attributes.notedate = {};
                    }
                });
            });
Hope it helps

Re: Default date of 1970 for date field at 2.3

KellyHutchins — Tue, 14 Jun 2011 15:24:22 GMT

I thought you were trying to set a default value. If the behavior has changed between 2.2 and 2.3 that may be a bug. I'll take a closer look.

Re: Default date of 1970 for date field at 2.3

MarkSmith — Thu, 16 Jun 2011 06:57:13 GMT

Thanks Kelly,

Just to clarify, I am not trying to set a default value, the problem at 2.3 is that a default value is automatically being set to 1970 for date fields. This did not happen at 2.2.

If the behaviour of the date fields can be restored to how it behaves at 2.2 then that would be great. Basically a null date value should not default to ANYTHING, let alone a random date of 1970, it should remain null until the user decides to input a date - and then the date picker should open on today's date for convenience. This is how it worked at 2.2.

Thanks again for your help,

Mark.

Re: Default date of 1970 for date field at 2.3

MarkSmith — Tue, 19 Jul 2011 07:01:05 GMT

If the behavior has changed between 2.2 and 2.3 that may be a bug. I'll take a closer look.

Kelly,

Have you been able to find anything out about this?

Thanks,

Mark.

Re: Default date of 1970 for date field at 2.3

derekswingley1 — Tue, 19 Jul 2011 13:18:17 GMT

Hi Mark,

I believe we fixed this at 2.4. Check out the What's New in 2.4 doc, specifically under bug fixes towards the bottom:

The editor widgets (attribute inspector, editor etc) display a default value of 1/1/1970 for null date fields. Null date values should display as null instead of the default date. (NIM070071)

Can you test with 2.4 and confirm?

Re: Default date of 1970 for date field at 2.3

MarkSmith — Tue, 19 Jul 2011 13:25:05 GMT

Hello,

Yes, this is now fixed at 2.4. Thank you.

Mark.

Re: Default date of 1970 for date field at 2.3

derekswingley1 — Tue, 19 Jul 2011 13:27:21 GMT

Thanks for confirming!

Re: Default date of 1970 for date field at 2.3

DavidHollema — Sat, 11 Dec 2021 21:19:56 GMT

Similar question, mind taking a look? http://forums.arcgis.com/threads/45726-Editor-attribute-inspector-default-values?p=156031

The attribute inspector date calendar displays the date stored in the feature's date field. New fields don't have a value so the default date of January 1, 1970 is displayed. You can modify this by setting the date's value to the current date (or whatever value you'd like) when a new feature is created. To do this listen for the feature layer's 'onBeforeApplyEdits' event and update the date for the newly added feature(s). In the sample below 'pointsOfInterest' is the feature layer whose date field you want to update.
        dojo.connect(pointsOfInterest,"onBeforeApplyEdits",function(adds,updates,deletes){
          //update the date field for new features to be today's date.
            dojo.forEach(adds,function(add){
              add.attributes.notedate = new Date().getTime();
            });
        });