Different date formats in Identify tool and SelectFeatures results display

Permanently deleted user

10. September 2015 17:01

Hi,

Someone might have already asked regarding this.

When i do identify operation on my map, the results table that is displayed shows any date columns in UK datetime format. But, when I am using Select Features activity from workflow, the result table displays date in US format.

What should I do to change the format. Is there any configuration change that needs to be made or should I do anything from workflow end ??

I tried to convert it to string and display, which works but sorting facility is not working for such way.

Thanks,

Srikanth

0

• 

  Kevin Penner

  11. September 2015 03:34

  As far as DateTimes go, Identify operations return a pre-formatted string from ArcGIS. When data is retrieved through a QueryTask, the times come back as a Long value (milliseconds since 1970) and the viewer is left to parse this value into a readable format.

  As far as I know there is no configuration to change this. Any solution for this is going to involve a crafty workaround. 

  -Kevin

  0
• 

  Permanently deleted user

  17. April 2020 23:36

  This is my issue as well.  I have a case open with ESRI.  In my enterprise geodatabase, I have two date fields.  The back-end database is SQL Server.  When I query the table directly, I do see times returned, but they are all midnight.  ArcGIS Server shows these fields as being esriFieldTypeDate.  And yet, Geocortex Essentials thinks they are DateTime fields.  While the Identify operation just shows dates, a Geocortex Workflow shows times.  The time is a problem on ESRI's end, but it's difficult to explain to a living family member that the city cemetery is not asserting that the deceased was born at a certain time of day, or died at a certain time of day, when I have done everything in my power to have software ignore the time.

  0
• 

  Kevin Penner

  17. April 2020 23:44

  Hi Roger, how are you writing the dates to the geodatabase? A quick workaround might be to write the data value in a string field that you want to display to the public. -Kevin

  0
• 

  Permanently deleted user

  20. April 2020 16:10

  Kevin: I am writing the dates to the geodatabase using ArcMap. I have verified that SQL Server shows no time information for these dates (or rather, it shows 00:00 times). The issue really is with ArcGIS Server and not Geocortex Essentials or the HTML5 Viewer. I have a case open with ESRI. You may be familiar with the option in ArcGIS Manager for the service under "Parameters" > "Date Field Setting" called "Values are adjusted for daylight savings". When this value is checked, the deceased person's birth date is returned as being 11 PM the day before, but the death date is returned correctly for midnight. When this value is UNchecked, the person's birth date is returned correctly for midnight, but the death date is returned as being 1 AM on the correct day. And when I say the date are "returned", I'm talking about a REST/JSON query and the date/times are in JavaScript milliseconds. It's quite strange behavior.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.