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

learn more… | top users | synonyms

9
votes
7answers
10k views

Selecting by month in date/time field using ArcGIS Desktop?

I would like to select by a specific month from my date/time field in ArcGIS, and just can't seem to find a statement that will work. I have multiple years and multiple days, but want to filter those ...
9
votes
1answer
336 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, ...
8
votes
2answers
2k views

Calculating Date Field with 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 ...
7
votes
1answer
6k 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 ...
7
votes
2answers
568 views

Parsing serial date in ArcGIS for Desktop?

I have imported a shapefile that contains a serial date number that looks like this: 41256.260799. I would like to create a new field that shows only the hour and second like this: 06:33. I've tried ...
7
votes
3answers
507 views

Can ArcGIS for Desktop auto populate Date Field with current date/time when feature is created?

I am using Arc Desktop 10.3.1 in a versioned environment. In the geodatabase for the service requests there is a field called Date Notified. I would like this field to be auto-populated with the ...
6
votes
1answer
195 views

How to make a automatic updated date and time field in QGIS 2.14?

I want to make a date and time upadated field as I edit an attribute field in this format yyyy-mm-dd 00:00:00 (= 2016-05-08 11:04:00) - my local date/time. The data is in a QGIS 2.14 shapfile and ...
5
votes
2answers
356 views

Calculating Quarter (Q1, Q2, etc) using Date field in ArcMap Field Calculator?

I am using ArcMap 10.0 and making a map where I symbolize on annual quarter (i.e. Q1 2013, Q2 2013, and so on by quarter through 2015). If a date field contains this: 01/15/2013, and I wanted to ...
5
votes
2answers
402 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. ...
5
votes
2answers
787 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 ...
5
votes
1answer
602 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 ...
5
votes
1answer
1k 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 ...
4
votes
2answers
222 views

How to create in QGIS shapefile a field that automatically returns the current date

I'm digitizing a shapefile in QGIS and I need to create a field that returns automatically the current date.
4
votes
0answers
61 views

Dynamically style geoserver layer with timestamp column --> age of entry

I have a a postgis table with point geometries and a timestamp column, which has the information when the point was created. This table is already loaded as a layer into geoserver. So now in ...
3
votes
2answers
625 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(...
3
votes
2answers
267 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 ...
3
votes
2answers
111 views

Using ArcGIS Desktop field calculator (python) to parse date

I'm trying to parse a datetime field using python (but have never used python for it before). I have a field that contains a valid date, but not a valid time... and other fields that have valid hour ...
3
votes
1answer
41 views

Can ArcGIS recognize an incomplete date?

I have a string field that I want to convert into a date field. The problem is that some dates are incomplete (ex: "-/-/1967"; "1/2/-"). So is it possible to have in the same date field complete dates ...
3
votes
1answer
422 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 ...
3
votes
1answer
37 views

Landsat 8 images acquisition_date

I need to know the exact date of image acquisition for NDVI purpose, the date on image name is " LC80920852014222LGN00" is in Julian date, but in meta data it says"acquisition_date>2014-08-10" , I ...
3
votes
1answer
839 views

Why is arcpy.CalculateField_management() writing 1899-12-30 00:00:00 instead of expected date?

I'm using ArcGIS 10.3.1 for Desktop to test before writing an answer to How to enter date with arcpy.GetParameterAsText with arcpy? I have written the test code below that I am running against a test ...
3
votes
1answer
1k 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
2answers
1k 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 "month/...
2
votes
3answers
466 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
1answer
65 views

Managing multiple dates in single column of shapefile using ArcGIS Desktop?

I have data example an organizations, which consists sl.no, name of organization, facility type, latitude, longitude starting date of facility.My problem is for particular facility i had two or more ...
2
votes
1answer
1k 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 ...
2
votes
1answer
47 views

Change Date to Future Date in Map Title Using Python or Dynamic Text [duplicate]

I'm trying to create a dynamic map title in ArcMap that updates based on current day + 2 days. For example, if I run the code on the 20th of a given month, the title should update to show the 22nd. ...
2
votes
2answers
109 views

Splitting vector file by date (year) but column containing dates in Day/Month/Year format?

I am using national accident data in QGIS and quite frankly the dataset is huge as it contains every recorded accident between 2005 and 2014. I've split datasets by field for a number of vector layers....
2
votes
1answer
160 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 ...
2
votes
1answer
2k 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
1answer
368 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. ...
2
votes
1answer
1k 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?
2
votes
1answer
68 views

QGIS filter on date value

I would like to filter on a date value (show only attributes with a date later than 1-1-2000 for example). The field is of QDate type. But doing so I get the message: "Type mismatch or improper type ...
2
votes
1answer
115 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 ...
2
votes
2answers
423 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
116 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 ...
2
votes
1answer
133 views

Join attributes by date in Qgis

I learned (thanks!) to use the join feature built into the layer properties, but in my case it doesn't work because data do not match perfectly. Infact shape refers to geotagged photos, csv is a log ...
2
votes
3answers
716 views

Field Type Date invalid when run in Python, but not in Model?

Using ArcGIS Desktop Advanced 10.1 and PyScripter When running the arcpy.FeatureClassToFeatureClass_conversion, I get the error that the field type of Date is not valid. However, when running this ...
2
votes
1answer
516 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
0answers
52 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
193 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
2answers
105 views

Remove time stamp from date field using field calculator

I'm trying to copy the dates from a field called InspectionDate (date data type) to new field called CompletedDate (date data type) but I don't want the time stamp to be copied over. How can I copy ...
1
vote
2answers
754 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
2answers
71 views

Create a raster with ranges from another raster

I have a raster that contains values ranging from 1-180. I am looking for a way to create a new raster where if the values of a cell in the original raster is between 1-10 the new raster cell gets the ...
1
vote
1answer
176 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 ...
1
vote
1answer
97 views

Finding the date of acquisition of Google maps in QGIS

How do i find the date of acquisition of the Google map on QGIS? Please help.
1
vote
1answer
606 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")...
1
vote
1answer
121 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 ...
1
vote
1answer
73 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
256 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 ...