Questions tagged [date]

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

Filter by
Sorted by
Tagged with
12
votes
3answers
6k 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 ...
14
votes
7answers
19k 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 ...
8
votes
1answer
12k 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
3answers
8k 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/...
14
votes
4answers
9k views

Converting string field into date field in QGIS

In QGIS 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 ...
7
votes
2answers
2k 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 ...
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 ...
2
votes
1answer
405 views

Converting time field omitting time and returning null values?

I have a time field in my shapefile that is formatted as HH:mm:ss.s It is a text field, and I want to convert it to a date so I can calculate time elapsed across rows (if there's a better way to do ...
8
votes
1answer
1k 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
1k 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 ...
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 ...
3
votes
2answers
4k views

Unique List of Image Dates from Image Collection in Google Earth Engine

I would like to create a list or array object containing a unique set of dates represented in an image collection for a given region of interest. I have a function that extracts and converts dates for ...
2
votes
1answer
308 views

non-editable date / UUID is not saved in attribute table

I'm using QGis 2.14.12 Essen on Windows 7 Professional. I want to set up a project that includes a feature class which has a non-editable° creation_date field and a non-editable UUID field. I have ...
1
vote
2answers
79 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 I'...
11
votes
3answers
5k 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 ...
4
votes
1answer
1k views

Change date format into readable format in GEE

I have code in GEE which create table with the sentinel2 mean NDVI data for certain period. my problem is that the table in the end has two column with the dates, one is the name of each image (not ...
4
votes
1answer
4k views

Changing date format in QGIS?

I have just created a date field attribute. In Proprieties > Fields of the layer I made this: And the attribute tables shows this: What I want to see is the date in this format: 07-01-2019 and ...
3
votes
1answer
2k 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
1answer
1k 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
210 views

Spatio-temporal joins in QGIS?

Does anyone know how to count points within radius of another point when a time/temporal condition is met in QGIS? I assume I need to create buffer zones, but I do not know how to then count ...
3
votes
1answer
3k views

Understanding Date Time Format output in ArcGIS REST API?

It looks like the output format for dates from the ArcGIS REST API at 10.1 is in ticks. Has this always been the case? Can it be changed at the server level or the request level?
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
2answers
540 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 ...
2
votes
2answers
94 views

to_date arranging dd/MM/yyy

I have a column as a string 10/12/2020 13:14:39 I want to convert it to Date format (I'll do that using the refactor tool later). First I need to rearrange this so the time is discarded and the dd/MM/...
2
votes
2answers
198 views

Way I can find out when a shapefile was created or last updated

I'm working with 100+ layers on QGIS, and I am trying to determine when each layer was last created or updated. All the layers are shapefiles. Is there a way I can find the creation/update date?
2
votes
1answer
85 views

Attribute table conversion date format

I want to change the date format with different date formats in the attribute table to the one format which is fitting for the Time manager. Does it work with the Field Calculator? For example 12....
2
votes
0answers
304 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 ...
2
votes
2answers
5k views

Converting from Julian Date to Calendar Date? [closed]

Does anyone know of a way to convert from a Julian date to a regular calendar date?
1
vote
2answers
984 views

Entering date with arcpy.GetParameterAsText()?

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 formatting....
1
vote
1answer
118 views

Rearranging display of Date Field in ArcGIS Desktop?

Can you rearrange the text in date field type in ArcGIS? Eg. Map_Date - 05/30/2014 (I want to reformat this to 2014-05-30) I've been trying to use the field calculator on all my records, but cannot ...
1
vote
1answer
1k views

Automatically adding date to attribute table in ArcGIS 10.3.1 for Desktop?

I am using ArcGIS 10.3.1 for Desktop. I am working on a polygon layer in GDB file and i want that every feature that have been created in the map will be the date of creation (date and datetime). I ...