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

learn more… | top users | synonyms

0
votes
1answer
36 views

How to convert date field value returned by REST API to correct date? [closed]

I performed a query on this USGS feature service of Airport locations: Click for query And the value for the field LOADDATE is: LOADDATE: 1411380301000 However, when I pull the layer into ArcMap, ...
2
votes
1answer
58 views

Importing CSV file with csvt data in QGIS (2.8) will not assign type “date” to fields

I have a dataset (in CSV) and am trying to add several fields with date information, so I can filter points based on this data and generate maps (in QGIS 2.8) which will form a chronological series. ...
2
votes
3answers
75 views

How do I symbolize by year, when date column has MM/DD/YYYY

I am trying to symbolize an SDE feature, so I can't add any new columns. The date column is formatted as MM/DD/YYYY. I would like to symbolize all 2015s as one symbol, 2016, 2017 as other unique ...
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 ...
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 ...
1
vote
1answer
51 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 ...
1
vote
1answer
42 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 ...
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 ...
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
2answers
104 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. ...
0
votes
1answer
114 views

query featureLayer using date field and Esri JS api

I can query a featureLayer in my javascript map to only show features meeting criteria for normal attributes (strings/integers), as below for example featurelayer.setDefinitionExpression("status = ...
0
votes
1answer
147 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 ...
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, ...
3
votes
2answers
105 views

How to add today's date into an attribute table using QGIS Processing modeler?

I am looking for a way to use the Processing modeler to add a date field to an output dataset in QGIS 2.6.1 I have tried using the field calculator algorithm without success. (Also the advanced ...
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 ...
1
vote
1answer
95 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
49 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 ...
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 ...
1
vote
1answer
60 views

how to get date from excel with xlrd as text in textelement

when I run the script below in arcmap in the python window the date gets print however I get the following error:Parsing error SyntaxError: invalid syntax (line 19) the date isn't showing as text in ...
3
votes
1answer
198 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 ...
1
vote
1answer
42 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 ...
1
vote
1answer
48 views

Select by attribute using date field values two days before machine date of ArcGIS for Desktop?

I have a date field within a file geodatabase of ArcGIS 10.2 for Desktop that I am accessing using ArcMap. An example of a value in this field: 19/11/2014 08:49:56 I want to select all rows that the ...
0
votes
1answer
54 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 ...
7
votes
2answers
524 views

Calculate Date Field - today's date from datetime.date.today

I'm working on part of tool that will use arcpy.CalculateField_management to add the current date to the attribut table. I've wandered far and wide on the interwebs and can't seem to find the ...
2
votes
1answer
73 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
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.
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
1answer
106 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
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
363 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 ...
1
vote
1answer
244 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 ...
2
votes
2answers
287 views

Date-format conversion

I'm using Time Manager and QGIS 1.8.0 and I am stuck at date-format conversion. Time Manager needs Gregorian format YYYY-MM-DD HH:MM:SS.ssssss in text field and I have thousands of records in ...
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
2answers
325 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 ...
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
1answer
182 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.
1
vote
1answer
148 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 ...
0
votes
1answer
381 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 ...
1
vote
1answer
497 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 ...
2
votes
2answers
170 views

ArcGIS date field to integer

I have a featureclass with a 'date' class field named 'ACQ_DATE' formatted as: 1-8-2013 24-7-2013 etc. As you can see the number of digits is not harmonized. I want to display the dates on a ...
2
votes
1answer
92 views

Problem adding dates into an existing feature class from an excel spreadsheet [closed]

I've been trying to load data from an excel spreadsheet into existing feature classes, but I've been having some trouble with the dates. I've written a script that compares the values in the ...
1
vote
1answer
157 views

Can I automatically save datetime for every entry in my spatialite tabel? [duplicate]

I'm using QGis and SaptiaLite. Is it pssible to store date and time in a field "datetime" for every entry automatically - maybe with some python code? Already existing datetime should not be updated. ...
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 ...
4
votes
2answers
483 views

Binding between QGIS custom form (Qt Designer) and date/time field in a SpatiaLite database table

For my attribute table I created a custom form in Qt Designer. The table has a date field and a time field. In Qt Designer there are widgets for entering date and time. But what data type is expected ...
3
votes
1answer
794 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 ...
0
votes
1answer
407 views

Geodatabase add current date and time to attribute

Is it possible in Arcmap 10.0 to create a geodatabase feature class that has a date field which auto populates with the current date and time, every time a new feature is created? Is this possible ...
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 ...
1
vote
1answer
429 views

Removing time from date field labeling in VBScript

I'm not at all experienced with writing VBScript for labeling purposes. Here is my code so far: Function FindLabel ( [Date_of_Birth] ) if not isnull ( [Date_of_Birth] ) then FindLabel = ...
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 ...
2
votes
1answer
643 views

Date Time Format output in REST API in 10.1

It looks like the output format for dates is in ticks. Has this always been the case? Can it be changed at the server level or the request level?