Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
32 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 ...
1
vote
1answer
458 views

Calculate date field using date variable and time attribute in a feature class

I have a string variable (fileDateString) with the date in this format: 20150404 In my feature class there is a text field with time in twenty-four hour UTC format. There is also 2 leading spaces ...
2
votes
1answer
2k views

How do I select all points from a range of dates?

Is there a way to select points from a range of dates to create a new layer? I want to clean up my data by making all points from previous years a separate layer but doing a selection by attributes ...
9
votes
1answer
390 views

Measuring distances between simultaneous points

I am working with GPS data and so I have UTM's with DATE/Time information. I have 2 groups of species (moose and wolves). I want to join the information from moose to wolves that match in time. So, ...
1
vote
2answers
2k views

Formatting Date Label in ArcMap

I was hoping someone could help me with this. I know this is probably easy but I am still new to ArcMap. I need to label pipe mains with the year installed but my attributes have the entire date. ...
5
votes
2answers
678 views

How to sequentially increment date field in ArcGIS

I have created a date field in my point shapefile. I want to input date their. I am able to do so. Now I want to create a sequential increment with 6 second interval from previous point to next point. ...
1
vote
1answer
904 views

Concatenate Multiple String Fields and Convert to Date field using ArcGIS Field Calculator?

I'm Working in Model builder using the calculate value tool. I have three columns - SignatureDay, SignatureMonth, SignatureYear - All three are string data types and all consist of just numbers for ...
2
votes
1answer
507 views

How to create input mask for data capture into File Geodatabase by ArcGIS for Desktop?

For example if I had a "date" field (d = day digit, m = month letter, y = year digit) I could restrict entries to dd-mmm-yyyy instead of any number of different entry types(e.g. dd-mmm-yy or mmm-dd-yy ...
2
votes
1answer
856 views

Add a certain number of days for a date field

I have one field for a permit decision date, and then I have another field for 180 days from that permit date. The permit date field has data entered, but the 180 day field I would like to calculate ...
3
votes
1answer
565 views

Using arcpy and script toolbox to add the date to a attribute table

I would like some information on how to add a date to an attribute table, by adding a user specified date in a script tool that will update the polygons attribute table. In short I have two polygons ...
8
votes
1answer
9k views

Converting ArcGIS date value to string reading in mm/dd/yyyy format using ArcPy?

I am writing an arcpy tool script in ArcGIS 10.0. In a fGDB feature class, I have a Date type field. I gather that the values in the Date field are stored as long integer dates, but they display in ...
2
votes
1answer
117 views

How to use a feature class attribute to look up values in a table and pass them as parameters to a function?

My problem: I have a set of points inside a polygon. My goal is to figure out how long it takes (in days) for each point to move outside the polygon, based on a daily movement which affects all the ...
0
votes
1answer
460 views

How to save time without date in shapefile's DATE filed using ArcGIS 10.2?

I am trying to save a time in a shapefile's DATE field (without a date, because shapefile can only store something one simultaneously - date or time). I use field calculator with PYTHON parser. I am ...
2
votes
1answer
128 views

Is it possible with Torque to show only the months where there is information to show?

I have a date column that ranges from 1998 to 2013, but each year the specific dates are always from the same three months (March, April and May). I would want to show only these months (where there ...
1
vote
1answer
526 views

arcmap layer export as shapefile, in the dbf file the time value is missing

In arcmap, I export a layer as shapefile. After that I find from the dbf file, the editor tracking date-time columns (created_date, last_edited_date) value only contain the date value, The time value ...
1
vote
0answers
81 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.
0
votes
1answer
1k views

How to format an attribute of type esriFieldTypeDate from a FeatureSet Graphic

Hoping someone can tell me if I'm going about this wrong, but I'm executing a QueryTask / Query on a map service and getting back a FeatureSet as expected. Within the attributes of each Graphic, I ...
2
votes
1answer
1k views

Invalid SQL-Statement error when querying file-geodatabase table date field with arcobjects

I want to query a DateTime Field in a table in a file-geodatabase and I keep on getting the error "invalid sql statement" (Error Code: -2147220985) while that sql statement does not give me an error ...
0
votes
0answers
237 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, ...
3
votes
2answers
1k views

How to set NULL as default value for a date field in QGIS 2.4?

In QGIS 2.4, i am unable to set the default value as NULL if i have not updated any value on date fields. Its automatically taking the current system date. I am expecting to set the default values(...
0
votes
1answer
437 views

Cartodb: How to make dates appear in Torque time slider

I am trying to use my date column as a time-slider in my cartodb map. But it doesn't appear or seem to be an option. What am I doing wrong? Here's my map: Map Here's my data: Thanks.
4
votes
1answer
1k views

How to filter date values using OGR 1.11.0?

With OGR 1.10.1 this works: ogrinfo test2.shp -sql 'SELECT COUNT(*) FROM test2 WHERE DATE < "1970-01-01"' Note that DATE is a column of type date (not string). (Here's test data if you want to ...
1
vote
1answer
2k views

Using Field Calculator to Add a Set Amount of Time to Date Field

I wish to georeference several photos to a track created using a Garmin Oregon 450t, but the time recorded in the photos and the time recorded in the .GPX are not the same. The format for the date ...
4
votes
1answer
7k views

How to correctly use Datepart( ) in ArcGIS?

I have two date fields dd.mm.yyyy with a start and an end date in my attribute table. Now I want only to extract the years from these fields to new fields. So I created another field, and used ...
3
votes
1answer
2k views

Definition query that returns based on date in arcgis

I was wondering if anyone knew how to build a definition query in Arcmap 10.0 that returns only features that are f.e. only 7 days old. I have a SDE geodatabase with polygons, each with a "date"-...
2
votes
0answers
289 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
201 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 ...
3
votes
1answer
2k views

How to create a date field in QGIS shapefile

When I create a new shapefile in QGIS, I'm presented with the "New Vector Layer" window, where I specify the Shapefile type (Point/Line/Polygon) and am then able to create attribute fields. I'm only ...