Questions tagged [date]

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

Filter by
Sorted by
Tagged with
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
0answers
219 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 ...
1
vote
2answers
3k 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 ...
0
votes
2answers
127 views

Format date in CartoCSS infowindow

I have a date feild in my data and when I add it to an info window, it shows in zulu time (2017-11-06T00:00:00.000). Is there a way to format the cartoCSS and HTML so that only the date, and not the ...
1
vote
1answer
384 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
170 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?
4
votes
1answer
365 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 ...
1
vote
1answer
55 views

How to extract data points based on date attributes

I have around 1.5 million data points of fire incidents during a period of 10 years. I want to extract each month into a new layer so then I will basically have 120 layers in total. Is there a way ...
2
votes
0answers
277 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 '...
1
vote
0answers
174 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 ...
4
votes
0answers
152 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 ...
2
votes
1answer
458 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 ...
3
votes
1answer
353 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: ...
2
votes
1answer
297 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 ...
3
votes
1answer
4k 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-...
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 ...
2
votes
1answer
552 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="...
3
votes
2answers
1k 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 ...
7
votes
2answers
566 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 ...
0
votes
0answers
73 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 ...
1
vote
0answers
325 views

Trouble-shooting Time Manager date format problem [duplicate]

I've been trying to format a field in a vector file in QGIS to be run in Time manager and, for some reason I can't figure out, it still is not running. I read the other threads here associated with ...
0
votes
1answer
102 views

How to display latest sample value for a point in QGIS?

We have a dataset consisting of points (x,y). At each of these points, analytical data has been collected at different dates. The dates are not the same for all points. An example of the dataset is ...
3
votes
1answer
197 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 ...
0
votes
0answers
101 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
1answer
195 views

Select by Attribute on a changing date

I want to be able to select by attributes for dates that change weekly. I have gotten an invalid expression error for the follow script where the date needs to change to the current date and the same ...
1
vote
2answers
2k views

Changing Format of Date Field in ArcMap Field Calculator?

I am trying to change the format of date field using ArcMap field calculator. My data is currently in the format "%d/%m/%Y %h:%m:%s" (e.g. 5/05/2016 12:25:46 AM) I want to change this to "%d/%m/%Y" (...
1
vote
1answer
641 views

Calculating between today's date and date field in attribute table ofArcGIS Desktop?

I am trying to use DateDiff to calculate the difference between today's date and the initiated date of various projects. I created a new field called "Duration of Day" and I tried the calculation: ...
1
vote
0answers
62 views

ArcGIS field calculator to calculate most recent date of 4 date fields? [duplicate]

Currently I am trying to use the field calculator to generate the most recent date values out of four fields into one field. I attempted to use the max function to calculate the most recent dates but ...
1
vote
1answer
145 views

Displaying time in the Date Field

How would one go about displaying the time that a feature was edited or digitized in a date field so as to display MM/DD/YYYY 12:00:00 AM in the attribute table?
2
votes
1answer
285 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 ...
3
votes
1answer
1k 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 ...
1
vote
2answers
4k 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 ...
6
votes
2answers
373 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 ...
2
votes
1answer
53 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 ...
1
vote
1answer
639 views

Output name with Current Date

My goal is to create a daily automated task using a model built from ArcGIS ModelBuilder, then exported to Python script. I would like the outputs of this model to have the name (Stat_) + today's date:...
1
vote
1answer
602 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
2answers
45 views

Introduce year instead of whole date in date type field using ArcGIS Desktop?

I have a field with numbers in it (concentration of chemical compounds that were presented in aquatic environments) and I'd like to combine them with a field which would have date type capabilities ...
1
vote
1answer
833 views

Python - Date notation to MM/DD/YYYY

I'm a complete beginner trying to update some fields in an attribute table (i.e. an ArcMap Shapefile) using Python tool. My goal it to update the values from this column to another date notation. ...
5
votes
1answer
2k 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 ...
4
votes
1answer
1k 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....
3
votes
1answer
493 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) | ...
1
vote
0answers
40 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
2answers
1k views

Getting days of week from date field, with field calculator? [closed]

I'm using ArcGIS 10.3.3 and have a field containing a date as following format M/D/Y. I need to get the day of the week based on my date field. I need to do this from the field calculator. Example ...
2
votes
1answer
363 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 ...
13
votes
4answers
7k 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 ...
1
vote
1answer
293 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
votes
2answers
164 views

Creating automated/self updating calendar date in map window of MapInfo?

Id like to know the steps involved in creating (within a map window), a calendar date, in the format dd/mm/yyyy in mapinfo, which updates every day as per the clock on the computer. I basically want ...
0
votes
1answer
1k views

QGIS filter by date in attribute table

I am trying to filter features within a shapefile for a specific date range. In the shapefile, one of the attributes is "date" and I would like to be able to filter it so it only shows a specific date ...
4
votes
1answer
107 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 ...
-1
votes
1answer
842 views

Format difference between list of dates and specified date in R? [closed]

I want to determine the number of days between each of a list of dates and a specified date - here 1987-01-01. Looking at other examples and using some example data I write: Example<-as.Date(c("...