Time stated in terms of the day, month, and year.

learn more… | top users | synonyms

4
votes
1answer
647 views

How to Query Layer using ArcGIS REST Services for Records with Date Closed Field less than 24 hours ago?

I am current trying to do layer definitions on a map and so I am trying to filter some records via a time factor so i was writing in the Where field DATE_CLOSED_ON > (CURRENT_TIME - 24) and ...
1
vote
1answer
54 views

Reduce number of points, keeping most recent data within a given distance

I have a HUGE dataset of points that were collected along a route. The data may change daily, and the most recent data is the most important. What I would like to do is take only 1 point from a given ...
1
vote
1answer
89 views

Coloring polygon based on date using TileMill/CartoDB?

How would you color a polygon/line/dot based on a date? The colors would be a pre-set list. I need the area to update its color based on the current (or given) date. I would be using tilemill or ...
0
votes
1answer
16 views

recognising “any date” in symbology?

Could anyone tell me how to select a date in the Symbology > Categories > Value field to express symbology for any cells that contain a date rather than having to add every date as a field to define ...
0
votes
1answer
23 views

BC Dates on cartodb.com?

I'm trying to use historical dates to build a torque map on Cartodb.com, with data going back to 8000 BC. But the date format doesn't seem to convert anything bellow 0100 01 01 (1st Jan 100 AD), and ...
0
votes
1answer
96 views

Date field formatting as number in ESRI popup window

We are using the Park and Recreation Locator from ArcGIS for State Government and trying to put a date field into the popup info window. The field is pulling the correct data, but it's formatting it ...
2
votes
0answers
36 views

Query out a specific date regardless of the time, using python

Problem: I have a feature class with an attribute table with a field called Edited_Date and its data in the field is as follows: 4/8/2015 10:00:00 PM. I want to select all records that are Edited_Date ...
2
votes
0answers
329 views

Problem viewing SQL 2008 “Date” field

I am using ArcMap Basic 10.1 SP1 and I'm connected to a permitting database stored in a SQL Server 2008 R2 database. I am trying to pull the tabular data over into my ArcGIS Desktop Project so that I ...
1
vote
0answers
49 views

Does qgis support postgresql range types?

I added a postgis layer with date range column in Qgis but that field is not listed in Qgis.
1
vote
0answers
144 views

openLayers and geoserver: WMSGetFeatureInfo does not return feature beyond wrapdateline

I built a map made of several layers. I need to display the layers features fields at the place where the user clicks (see the controler code hereafter). The layers are correctly displayed and go ...
1
vote
0answers
89 views

How to transform Invalid Date format in Data Interoperability

My workbench is running into some date data it is rejecting. Here is the error I'm receiving... The invalid value '20100419000000' was supplied to the field 'install_date_orig' I believe the feature ...
0
votes
0answers
34 views

arcmap display full date

I am working with arcmap software. I have a points layer that was created from a gps device. this layer contains a few tracks from the same day (e.g driving to work in the morning, returning home, ...
0
votes
0answers
22 views

Why are date fields missing when creating unique symbols in ArcGIS Online?

In ArcGIS Online, I am trying to customize a map with custom symbols using a date field. In the To Show drop-down list, I see all of my database fields, except for the date fields. The feature layer ...
0
votes
0answers
61 views

Conversion from string decimal date format into field with date format using ArcGIS for Desktop?

Using ESRI ArcMap 10.2 , I am trying to convert a text field in a shapefile that holds dates in a decimal format into a usable date formated field, but I can not for the life of me figure out the ...
0
votes
0answers
34 views

WhereClause to get the row with least datediff to given date

I have an SDE running on Oracle10-database from that I need to retrieve that row that has least datediff to a given date. So I tried to order the rows and get the very first row, but I do not have a ...
0
votes
0answers
74 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...
0
votes
0answers
306 views

Date Parameter in model builder - ArcMap

Basically I'm building a model where the user has to select the data from a drop down list and the result is executed. I have a problem when trying to pass a date as a parameter. Below you can find ...