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

learn more… | top users | synonyms

0
votes
1answer
43 views

Definition Query to find next date value in ArcSDE attribute table?

I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one ...
0
votes
1answer
35 views

Incorrect time displaying in ArcGIS Javascipt popup template

I'm creating a web map that is updated a few times a day showing voltage readings from meters on our distribution network. This layer has a field called ReadTime, and the data type is Date. The date ...
0
votes
2answers
64 views

How to enter date with arcpy.GetParameterAsText with arcpy?

I want to allow users to enter a date as a parameter through a dialog window in a toolbox script. I have obviously defined the field with a "Date" data type but something is wrong with the ...
0
votes
1answer
43 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
84 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
93 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
40 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
18 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
63 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
48 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
60 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
144 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. ...
1
vote
1answer
166 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
163 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
42 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
120 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
27 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
103 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
61 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
71 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
71 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
215 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
45 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
55 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
65 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
643 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
76 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
51 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
37 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
118 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
99 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
397 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
273 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
354 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
110 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
414 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
84 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
203 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
165 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
437 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
582 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
198 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
94 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
173 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
151 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
508 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
871 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
454 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
333 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 ...