Questions tagged [date]

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

0
votes
1answer
19 views

Selecting multiple date ranges using Select By Attribute?

Using ArcGIS Desktop 10.6.1. I'm interested in selecting multiple date ranges using Select By Attribute. I've verified that each date range works. For example Date >= '2015-04-15' AND Date <= '...
3
votes
0answers
170 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 '...
2
votes
0answers
156 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
287 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
0answers
47 views

Datetime on attribute tables

I have written a script to add, among other stuff, a datetime column. I have used the arcpy.AddField_managementcommand, but it didn't have a 'Datetime' type, so I used the 'Date' type : arcpy....
1
vote
0answers
111 views

ogr2ogr: filter on date-field

ogr2ogr -spat_srs EPSG:31370 -spat 179600 167350 179800 167500 -f "ESRI Shapefile" test.shp "WFS:http://ccff02.minfin.fgov.be/geoservices/arcgis/services/WMS/Cadastral_Layers/MapServer/WFSServer?" ...
1
vote
0answers
137 views

Converting double to date field using QGIS?

In ArcMap I have a table with a column with the date type yyyy-mm-dd, but after opening SQlite in QGIS, this column is written as a double type. How do I convert data in the form of a number to a ...
1
vote
0answers
37 views

define startMonth for jqtimeline plugin in a webmap

I created a webmap with timeline function by using leaflet.js and jqtimeline plugin. Do you know a possibility to not just define the startYear but a startMonth with jqtimeline plugin? The reason is ...
1
vote
0answers
346 views

ArcGIS Server Rest API date issue

I am using "date '2015-8-10'" in ArcGIS Server REST API to retreive records from map services. But it returns the error "Fail to Execute". My date is stored as "10-AUG-15". When it is in the right ...
1
vote
0answers
116 views

qgis 2.8.1 date filter gives incorrect selection results

I am running QGIS 2.8.1 on ubuntu 14.04 x64. I applied a date filter to a shapefile using the layer Properties_General "Query Builder" button. So the query was "LOCATION START DATE" >= '01/01/...
1
vote
0answers
79 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.
1
vote
0answers
198 views

How to transform Invalid Date format in Data Interoperability

My workbench is running into some date data it is rejecting. Here is the error I'm receiving... The invalid value '20100419000000' was supplied to the field 'install_date_orig' I believe the feature ...
0
votes
0answers
10 views

Creating polygon for each day from table with change of area over time (by day) using ArcGIS Pro?

I have a .csv with data in rows over time (date field and multiple attributes for each day) of the same single area - the fields are high temperature, low temperature, humidity, precipitation. I want ...
0
votes
0answers
25 views

Selecting values with date-format by using SelectLayerByAttribute_management with input Parameter

I am working on a Tool which selects records depending on the input value. Works fine, till I want to select date-records. I used def buildWhereClause(self, table, field, value): # Add DBMS-...
0
votes
0answers
64 views

Format ArcMap Date format

I am really new to Python and I am trying to create a tool using arcpy where I am using the calender as the data type for one of the parameters in the tool. The date format ArcMap is giving me is ...
0
votes
0answers
74 views

How to get work time-series with AM and PM data?

I read tutorial and get all work with data like 20170526, but how to get it's work if I have AM and PM data for specifieded date? As I understand from docs date placing and shp to date field, and ...
0
votes
0answers
233 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, ...