Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [date]

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

Filter by
Sorted by
Tagged with
12
votes
7answers
17k 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 ...
11
votes
3answers
4k 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 ...
10
votes
2answers
7k 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 ...
9
votes
3answers
3k views

How to convert a string field to a date field

I have a layer with points which represent the fatal road accidents and the field "dates_14_D" contains their date but its type is string. I would like to convert this string field to date field but ...
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, ...
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 ...
8
votes
2answers
3k views

Making automatic updated date and time field in QGIS?

I want to make a date and time updated 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 shapefile and ...
8
votes
1answer
659 views

Display full date-time, even when the time is 00:00:00

I have date fields in Oracle tables. When I view the data in the attribute window, the dates are displayed like this: 1/1/2017 1/2/2017 3:50:28 PM As demonstrated in #1, ArcMap doesn't show the ...
7
votes
4answers
979 views

Parsing serial date in ArcGIS 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
2answers
123 views

QGIS 3.4 calculate date, add month

I want to add a number of months to a date to get a new date. I have a date-field "date", an integer-field "months" and a date-field "new_date". I want to calculate the "new_date" by adding the "...
6
votes
3answers
7k 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/...
6
votes
2answers
537 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 ...
6
votes
1answer
188 views

Adding date to label in QGIS Atlas composer?

I'm trying to add the current date into a label for use in a composer for colleagues to run on a daily basis. The label is currently; Bins to be delivered: [% "Count" %] All I need to add is the ...
6
votes
1answer
5k views

QGIS filter on date value [closed]

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 ...
6
votes
2answers
1k views

Binding between QGIS custom form (Qt Designer) and date/time field in 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 ...
6
votes
2answers
408 views

Creating yyyy-mm-dd column in attribute table from Julian day in QGIS?

I am using the time manager for a set of data and I need to create a column in my attribute table of the date in the format yyyy-mm-dd. I already have a column in my attribute table that contains ...
5
votes
2answers
762 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....
5
votes
2answers
694 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
311 views

QGIS date fields widget - unable to select todays date?

This is something that I have lived with for several months as there is an easy workaround, but I thought I'd see if anyone knows of a solution, or whether it is a bug. In Layer Properties > Fields I ...
5
votes
1answer
873 views

QGIS Conversion to_date doesn't work

I have a table with one of the fields named Date_Time. The features are like 21-5-2016 14:47:00 (field type is string). I want to extract the dates and add them to a new field with the Conversion ...
5
votes
1answer
1k 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
2k 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
601 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
1answer
9k views

Applying a definition query to date field for feature in file geodatabase

Is it possible to apply a definition query to show data for today, yesterday and two days ago for a field where the data type is 'Date'? I have a script that downloads MODIS fire data and wish to ...
4
votes
2answers
890 views

Adding today's date into 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 ...
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 ...
4
votes
1answer
59 views

How to determine the right time of Landsat 8?

Sorry, please help me clarify this issue. Assume that I have information from a Landsat 8 image with the time shown as below: Start time: 2018:288:03:13:25.1532590 Stop time: 2018:288:03:13:56....
4
votes
1answer
786 views

Why does shapefile's dbf convert YYYY date to YY-format?

I save date from database's timestamp to shapefile date attribute. For example, I took from database [2031,10,31] and set it to '31.10.2031' at shapefile using python's shapefile.py as sh: self.sh....
4
votes
1answer
102 views

Date Formatting Mess

I am trying to format a date field that underwent incorrect importation. The result was that the date format became coded in a way i am unsure of. Is there a simple way using the field calculator ...
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 ...
4
votes
2answers
1k views

Transforming 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 ...
4
votes
1answer
210 views

Setting DATE as default column type for esriFieldTypeDate in ArcGIS Desktop?

If I use esriFieldTypeDate with ArcGIS 10.2 a DATE column is created in Oracle. If I use it in ArcGIS 10.6 a TIMESTAMP(6) is used Is there a way to set DATE as default column type for ...
4
votes
1answer
2k 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 Entering date with arcpy.GetParameterAsText()? I have written the test code below that I am running against a test feature class ...
4
votes
2answers
4k 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. ...
4
votes
1answer
772 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 ...
4
votes
0answers
106 views

Using JavaScript variable as date parameter in SQL view [closed]

I'm creating a map based on an SQL view in GeoServer, and I want the layer to change depending on the date parameter in the SQL view (%date%). It works when I set my variable to 'current_date', but if ...
3
votes
1answer
901 views

Python Max Function in Field Calculator for Date values

I have 4 fields with Date Time values, and created a new field (Date type as well) which takes the most recent date from these 4 fields. I have tried using the Max python in the field calculator to ...
3
votes
3answers
4k 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 ...
3
votes
2answers
662 views

Filter a shapefile by date in the Query Builder of QGIS

I have a shapefile that I'm trying to filter by date (i.e. START_DATE). This same query START_DATE = '2007-07-25' works in the Attribute Table > Select features using Expression, but not in the ...
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(...
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 ...
3
votes
2answers
436 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
50 views

Change data format in QGIS field calculator using format_date

I´d like to change the data format in the attribute table from yyyy-MM-dd (default) to dd.MM.yy using the format_date function in the field calculator. Using: format_date(date, 'dd.MM.yy') I got ...
3
votes
1answer
379 views

QGIS: How to convert date values with format d-m-yyyy in a string field, into date values with format yyyy-mm-dd in a date field?

I have date values with the format d-m-yyyy in QGIS. They are in string field. I want to convert them into date values with the format yyyy-mm-dd. I want them in a date field. Can this be done ...
3
votes
1answer
437 views

Editing date in *.ssf files?

So my trimble TSC1 Pro XRS (bought in 2000) is getting old I guess and it change byitself the date. I collected data this week, but it indicate from 1998. I view this info because I can't apply ...
3
votes
1answer
195 views

FME shapefile writer NULL values in date format fields

I have a data source with string fields containing dates formatted like 20180202120000 (YYYYMMDDhhmmss) and I would like to write these in date fields in a shapefile using FME (2016.1). UPDATE: ...
3
votes
1answer
53 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
405 views

Reducing number of points, keeping most recent data within given distance, using QGIS?

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 ...
3
votes
1answer
569 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
446 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 ...