Date Format
Has anyone figured out how to get the dates displayed in the HTML5 viewer to be somehting other than this short essay about the date/time?
Sun Jul 14 2013 19:00:00 GMT-0500 (Central Daylight Time)
How can I get a simple, short date in a format like 07/14/2013?
-
Inside essentials, it is not easy. The easiest way would be to use a view to format the date/time field as you wish using the relational databases' internal formatting tools. For related data (data link), you can also do the formatting right in the SQL command. You can get access to this in the advanced button when looking at the data link. Just use your native database commands for formatting. Best test it in SQL Plus (Oracle) or SQL Server's management console.
Shawn.
0 -
I would like to remove time as well. The date/time attribute is presented in Results through ArcGIS server, not related data. In the source GIS data, there is no time, but when it is published through the service, the date/time unit appears through the REST call. Can something in a workflow help to remove the time portion?
0 -
@Latitude - This would be useful to my users also. Similar situation, specifically we're linked excel tables that do not display the time until viewed in GE viewer.
Thanks.
0 -
My time fields show date and time as well. Really annoying.
There's gotta be an option somewhere in SQL or thru the MXD to hide the time portion?
ken
0 -
something like this should work assuming you have a field named "start_date"
Format(START_DATE, 'yyyy/mm/dd') AS [Start Date]
0 -
Thanks for the suggestion, Zach. But where do you use that code? Somewhere in the ArcMap settings? In Geocortex? The code does not seem to fit with the way Geocortex works - they use curly brackets around the field names.
Mike
0 -
navigate to the map button on the left, click the edit button for the layer with the data link, click on the Data Link tab at the top, then click on the sprocket for the advance editing on the right side and you'll see the screen i pasted in below. The command box is where you'll need to add to your date field to format how it will look in your silverlight app. I had an example that showed the SQL, but the site has been altered and the link no longer is being used, sorry about that. The screenshot below is jsut to point you to the correct edit screen.
/customer/servlet/servlet.FileDownload?file=00P6000000elzoWEAQ
0 -
Thanks for your help Zach. But I don't think I can do that. If I understand correctly, I can only link to certain connection types - not including file geodatabases, which is what we are using.
Thanks,
Mike
0 -
yes, Data Connections are for ODBC/OLE DB/SQL, etc.
I believe you would have to change the formatting of your feature class field to display the way you want it.
0 -
Kenneth,
Have you figured out your time/date issue? I have the same problem. My date fields do not have time in them but GeoCortex uses a DateTime format and adds 12:00:00 AM to all of my date fields. I would like to remove it. Any ideas?
Screenshot of how field looks in ArcGIS:
/customer/servlet/servlet.FileDownload?file=00P6000000e88SEEAY
Screenshot of how field looks in GeoCortex Silverlight viewer:
/customer/servlet/servlet.FileDownload?file=00P6000000e88TaEAI
0 -
We are having this issue as well with the Silverlight client. What is even more odd is when adding an ESRI REST service that uses an esriFieldTypeDate it is adding a time field to some rows and not others. The esriFieldTypeDate is an integer, UNIX Epoch, the number of seconds since January 1st, 1970.
The time is set to 12:00:00 AM when the client computer has it's timezone set to GMT, or 7:00:00 PM when set to our time zone (-5 hours). It's a rather significant issue for us, as it is simply wrong to tell our users that a transaction happened at 7:00:00 PM when it did not.
0 -
I raised this issue a while back with LG and they are essentially saying that we should all be saving dates as UTC, which I don't think is a great idea, or at least it should be an option!
try using the edit tools and fields with dates in them, the times stored will be 11 hours (well for us in Melbourne) behind what I added. Really frustrating, and inherently wrong when you consider we are set up for mapping fire perimeters etc, in emergency situations and their tools are not storing 'local' time. So arcmap will now show UTC times and the GE client local, although the map tips in GE silverlight will show UTC.. so even more confusing for the user.
I'm not sure this is fixed at 4.0/2.0 but it needs to be considered.
here's the earlier thread on the date offset issue - happy reading!
(https://support.geocortex.com/EssentialsGSCForum?sub-nav=forum&main-nav=Essentials&#!/feedtype=SINGLE_QUESTION_SEARCH_RESULT&id=906600000000AtqAAE) https://support.geocortex.com/EssentialsGSCForum?sub-nav=forum&main-nav=Essentials&id=906600000000AtqAAE
0 -
First of all, that sounds like an awesome application.
Second, you can't control the date/time formatting for the feature description or long description. The workaround I've used is to add a field to my dataset and convert the date field I want to use to whatever string format I want it to be in.
0 -
I talked to tech support about it and it is now on their priority list for future releases.
0 -
+1
0 -
While we are at it, can we please not be stuck with US date format, when the vast majority of the population of the planet doesn't use it?
0 -
+1 please.
0 -
+1
0 -
+1 more
0 -
+1
0 -
+1. Latitude developers please address this ASAP.Thanks.
0 -
+1
0 -
in workflow i tried to convert the result of a date field to string then to datetime object to get the correct value. but all failed. i could not make the value "1/13/1987 12:00:00 am" to "1/13/1987". Then i decided to use substring function to get first 10 characters of the date value, datestring.substring(0,10). Now i got the date to display the way i wanted. I have not done more tests on this. so far seems work ok.. hope this help. hopefully this will get fixed. 0 -
Hi Li,
Where did you used datestring.substring(0,10)?0 -
+1 0 -
Hi,
In the new Geocortex Essentials 4.5.1, you are able to format how the dateTime format looks in the Feature Details Pane under Essentials Manager > Site > Map > Layer List > Edit the Layer > Fields Tab. You need to first add the column in question to the table by clicking on "Add/Remove Fields" and select the dateTime column. Then you click on "Edit the Item" to see the Edit Field wizard. Under "Date Format", you are able to adjust the date to whatever format you like:
_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=90760000000TUK6&feoid=Body&refid=0EM60000000Lztm" _/_img_
I hope this helps.
Regards,
Carmen1 -
Thanks for taking the time to write the reply, Carmen! :) 0 -
Hi,
Thanks for this suggestion Carmen. Unfortunately this will not work in my case as I am trying to remove the time from an ArcGIS Tiled Map Service, rather than a layer. In Essentials Manager there is no Fields Tab for a Map Service, therefore I cannot Add/Remove Fields from this.
Has anyone else encountered any dateTime issues relating in particular to a tiled Map Service and was able to implement a fix??
Any help would be greatly appreciated!
Many Thanks,
Pamela0 -
Carmen - This doesn't seem to be working. I edited as described above as well as the Default Formatting section below the field section. I still get the time in my results. 0 -
Hi Pamela and Diane,
Yes, unfortunately this fix is not available for tiled map services. In this case, I would suggest you adding this to our Ideas board here (https://support.geocortex.com/GSCIdeas?c=09a6000000008RsAAI&filter=1&categ=all&sub-nav=ideas&main-nav=essentials&page=1) so our developers are aware of this issue. If a lot of clients vote for this, then it will be implemented faster in a future release. In terms of a workaround for now, is it possible to remove the date/time column from the tiled service and then republishing it? Otherwise, if you want to keep the date/time field but change the format it is in, I would suggest converting that column into a string and then formatting the date/time so it is in a format of your liking before re-publishing.
Diane, in terms of removing the date/time field from the results altogether, you need to hide the column by going into the Site > Map > Layer List > Edit Layer > Fields tab. Here you can add or hide certain columns in the viewer (by clicking on the eye icon once the field has been added to the table) so the user will only be able to see the columns of your choosing. There is more information on this topic in the Administrator Guide under section "41 Fields".
I hope this helps.
Regards,
Carmen0
Please sign in to leave a comment.
Comments
31 comments