Questions tagged [date]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
291 views

ogr2ogr, force DATE cast on a SQL request

I am trying to complete column null values on a .shp file with one default value. My column has a DATE type. Files schema : "COLUMN_NAME TYPE(SIZE)" Input (with null values) : CLICHE VARCHAR(80) | ...
3
votes
1answer
2k 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"-...
3
votes
0answers
182 views

Current date in query builder Qgis

I'm trying to put a query on a vectorlayer with the current date. The following code works, but I want the current date to be dynamic: cast ("Starttijdstip" as character) < '2018/03/01' AND '...
3
votes
0answers
73 views

Query out a specific date regardless of the time, using python [closed]

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
3answers
123 views

Batch rename MODIS data?

I have MOD13Q1 NDVI images. Data are named in this format: MOD13Q1.A2007049.h26v06.006.2015161224938_MODIS_Grid_16DAY_250m_500m_VI.tif (YYYYDDD) Here 2007 is a year and 049 is day in year. I ...
2
votes
3answers
2k views

Symbolizing 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
2answers
2k 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?
2
votes
1answer
285 views

Deleting rows using UpdateCursor and date field

I have a large script, in which a part of it wants to check whether a shapefile has attributes in the "Valid_From" date field. If they match the date variables already created, these need to be ...
2
votes
1answer
2k 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 ...
2
votes
1answer
73 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
409 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 ...
2
votes
1answer
133 views

Style features based on difference between current date and date in attribute table

In QGIS >2.18, is it possible to style features based on the age gap between the current date and date recorded in the attribute table. For instance I have purchased a significant amount of OS data ...
2
votes
1answer
266 views

Dynamic date range for layout element in ArcMap 10.5

In ArcMap I would like to setup an MXD to have a dynamic element that displays a date range. It is easy enough to add dynamic text that displays the current date using the following: <dyn type="...
2
votes
1answer
332 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 ...
2
votes
1answer
1k 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
1answer
236 views

Filter Specific dates in Google Earth Engine?

I've called Landsat8 images from 2014 to 2019 using filter date function. But I don't know how can I call Landsat8 images only for June, July, and August from 2014 to 2019? Map.centerObject(geometry);...
2
votes
2answers
87 views

Show “!” label when the date is close

In the attribute table I have a column "the end of the contract" with date. I want QGIS to show me the label "!" when there will be 30 days or less until the end of the contract.
2
votes
1answer
225 views

Displaying vector layer added using Add Vector Layer in QGIS?

Scenario I have a .csv file containing (amongst others) some date fields, and a matching .csvt file defining the correct field data types. The only way I have been able to add my .csv data and have ...
2
votes
1answer
291 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
1answer
2k views

Querying featureLayer using date field and ArcGIS API for JavaScript?

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")...
2
votes
1answer
862 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
870 views

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

I'm using QGIS and SpatiaLite. Is it possible 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
2k 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?
2
votes
1answer
1k 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
52 views

Store and retrieve date of geoproccessing in feature class

I have geo-processing models and scripts that are run on existing feature classes. The models and scripts truncate(delete) the rows in feature classes, and then append new rows. The geo-processing ...
2
votes
1answer
825 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.
2
votes
1answer
117 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 ...
2
votes
1answer
217 views

Add Date to raster layers in raster stack in R

I have a raster stack and I want to add to it a Date field which will include the year-month-day for every rasterlayer. I have my dates in a one column data.frame. I tried to do this with addLayer ...
2
votes
1answer
278 views

Selection of rainfalls seasons for Sentintel-2 data in Google Earth Engine

I want to filter the Sentinel ImageCollection for the rainseasons of my ROI (March to may AND October to December) for all data available (2015-2018). With .filterDate(startdate, enddate) I can only ...
2
votes
1answer
190 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 ...
2
votes
1answer
221 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 ...
2
votes
1answer
507 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
128 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
1answer
760 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
1answer
134 views

Adding dates into existing feature class from Excel spreadsheet using ArcPy? [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
197 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
937 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
0answers
171 views

QGIS - Default Date Formats

I manage a fairly large estate of QGIS installs in the UK and am looking to set the default date formats to the uk dd/mm/yyyy format from our MSSQL data warehouse. Its set and works correctly in the ...
2
votes
0answers
289 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
666 views

Using ArcGIS definition query for dates?

My attribute table contains a Start date in m/dd/yyyy format. I would like to build a query that only shows data from current month forward. Does anyone know how to build a query or expression for ...
1
vote
1answer
88 views

Converting Long to Date in ArcGIS Pro?

I have a field that is a Long type which represents a date. It is in YYYYMMDD format. (Example 04/10/2018 is 20180410.) How do I convert that Long to a Date type using ArcGIS Pro 2.1?
1
vote
2answers
718 views

Create 'Season' column from 'Date'

I'm somewhat familiar with ArcGIS Desktop, but have no experience in Python. I have about 100 shapefiles which have an attribute table containing a date, but I need a column which contains a ...
1
vote
1answer
434 views

Changing format of dates in ArcGIS 10.2 table

I am working with a table in ArcGIS 10.2 with over 500 entries containing dates. I am looking for a fast solution to transform the format of dates, from dd/mm/yyyy to mm/dd/yyyy. So if a date is 10/...
1
vote
1answer
200 views

MapBasic subtract date columns

Is it possible to create a MapBasic SQL command to subtract one date column from another and get the number of days between the two (positive or negative values)? I have found the following process ...
1
vote
1answer
648 views

Changing Date Format via Field Calculator of ArcMap?

I'm trying to find a function in the Field Calculator (preferably in VB Script) that can add numbers into a field that already has data. I have year data ranging from the 1960s to 2014 in string ...
1
vote
2answers
2k 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
839 views

Getting 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
44 views

Locating date, scale, and coordinate system of shapefile in ArcMap?

I am trying to locate the date, scale, and coordinate system/projection of a shapefile in ArcMap but when I right click on the file in the table of contents and go to properties, I don't see the date ...
1
vote
1answer
192 views

ArcMap - Field Calculator / Calculate Value - extract month of median date between two dates

I have a String field 'INTERVAL' giving the two dates used for a difference image in the form "YYYYMMDD_YYYYMMDD". I would like to populate a second field 'MONTH' giving the month of the median date ...
1
vote
1answer
2k views

Filter image collection with a date list in Google Earth Engine?

I know how to filter with a date range in Google Earth Engine, but I would like to filter a list of concrete dates which aren't consecutive, single days, for example, ['2005-08-05','2009-09-01','2017-...