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
0
votes
1answer
30 views

GEE error when extracting image timestamp

I have filtered Sentinel 2 images to get suitable cloud free images from the time period I require, however I cannot figure out how to extract the date from the images, but with my current code I get ...
1
vote
1answer
16 views

Adding time band as year to NDVI composite

I try to add time band to my NDVI time-series and using this function (took it from developers guide), for regression calculation. It looks like script is working but magnitude of slopes is extremely ...
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 "...
0
votes
0answers
30 views

Updating Date Field based on date value ONLY from another field using ArcGIS Field Calculator

In ArcMap 10.4 I have the following code in Pre-Logic Script Code Section in Field Calculator with python option selected and show code block: from datetime import datetime def myfunction(date_text):...
0
votes
1answer
23 views

Definition Queries for most recent date in ArcGIS Pro

I have a feature class containing sample results for locations that includes thousands of records. Many of these are overlapping and have the same location ID. I need to label each sample based on the ...
1
vote
1answer
68 views

Calculate date difference (days) with expressions (QGIS)

I would like to calculate the number of days between two dates. The first date is written in attribute table [YYYY-MM-DD] (creation date) and the second is today [now()]. The goal is, to get the age ...
1
vote
2answers
29 views

Which time format does ESA use for Sentinel-3 file names?

regarding the ESA Sentinel-3 file name convention I have got a question; which time zone (GMT, CEST, ...) does ESA use? I could not find anything yet, even it should be a critical point for many users....
1
vote
1answer
41 views

Calculation with Date in Earth Engine?

How can I add or subtract from a date in Google Earth Engine? See my codes here- var imagedate = ee.Date(collectionLT05_1991_1.get('system:time_start')); var imaagedate1 = imagedate+1; print(...
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 ...
0
votes
1answer
67 views

Grouping wildfires dates by season and getting sum and count using ArcPy?

I am having some trouble creating a new shapefile and CSV to group wildfires into seasons. What I want to do is to group the wildfires by meteorological season (summer, fall, winter and spring) for ...
0
votes
0answers
31 views

Google Earth Engine timelapse video: How to display the date (year) of each image in the video? [duplicate]

I'm currently producing Timelapses with Google Earth Engine. I have produced the video but I haven't found a way of adding the Date (or the Year of the picture) to the different images that are being ...
0
votes
1answer
26 views

Pulling date from filename and in proper format for time enabled use?

My feature attribute table has a folderpath that indludes a date time. Example:/documents/foldername/xyz2015OCT15063333.shp It seems very simple, but I am not a programmer and have done my best to ...
0
votes
0answers
45 views

Sorting Identify feature results by DATE field in ArcMap?

I'm using ArcMap 10.3. When I use the Identify tool, I often have many results and would like to sort those results in the Identify window. If I right-click on the layer name or features in Identify ...
0
votes
2answers
41 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 <= '...
1
vote
1answer
45 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
0answers
55 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
1answer
38 views

Storing date in m-dimension of PostGIS geometries

Do you know if it is possible to assign a date (whatever the format) as the 4th dimension to a geometry in PostGIS? If so, does it recognize it as a date?
0
votes
0answers
12 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 ...
1
vote
1answer
72 views

How to have a date earlier than 1753 in QGIS date field?

I'm trying to map out some of my family tree but I've stumbled upon a problem of not being able to put in early dates. I created the shapefile in QGIS and included a date field (dd-mm-yyyy). Whenever ...
2
votes
1answer
275 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
1answer
285 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 ...
0
votes
0answers
27 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-...
2
votes
1answer
598 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
3answers
137 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 ...
0
votes
1answer
42 views

Selecting points in polygon in a range of time (ArcGIS)

I have: - point GPS for people (time in seconds) - buffer GPS for a car (time in seconds) What I want to do is for each buffer GPS coordinate, I want to find the number of GPS people points inside ...
0
votes
1answer
34 views

Add default month/day to known year in new date field?

I have a text field featuring a 4 digit year. How would I assign a default month and day to the year in a new date field? ex. 2010 needs to be converted to 1/1/2010 I attempted this in the field ...
1
vote
1answer
156 views

Filter a date interval (month) shapefile

I'm trying to filter some data of a shapefile (with "Filter") for QGIS to show points in a date interval of a shapefile. I have a shapefile which has a table of attributes of sightings of animals with ...
1
vote
1answer
215 views

Filter Google Earth Engine image collection between today and 10 days ago

I wrote a small script that filters GEE image collection by date that I'm manually change: var start_date = '2018-11-02' var end_date = '2018-11-30' // choose image collection var ls8 = ee....
0
votes
1answer
43 views

Stripes between 2 images of Sentinel 2A (Level-1C)

Why do i get these stripes between 2 images of Sentinel 2A? (Figure) I notice that this happened for 2 images of different sensing date (even they're just 3 days away). Has anyone had this ...
1
vote
1answer
226 views

QGIS: Symbolize by date field based on current date

In QGIS 3.2.3: I have a layer/Shapefile with a date field (type DATE) that comes from a joined table. I would like to symbolize the points which are older than 10 days (based on the current date) in ...
1
vote
1answer
506 views

Arcade expression to see if current date is within two dates?

I am new to building expressions in Arcade and I am having trouble writing an expression that can be used to check start and end times of different areas and evaluate if the current date is within the ...
2
votes
1answer
1k views

Converting ee.Date object to client string in Google Earth Engine?

I'm trying to export all the images in an ImageCollection to Google Drive and by default name the output image with the date using format() function. However, when I try to name a export task by a ...
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....
1
vote
1answer
117 views

Stack RasterDataset taking into account the dates between images

Good morning, I would like to stack a raster dataset taking into account the number of days between images. Sometimes the number of dates between observations are 8, 16 or 365 days. Is there any ...
1
vote
0answers
143 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?" ...
2
votes
2answers
90 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
144 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 ...
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 ...
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 ...
1
vote
1answer
35 views

Changing date format in field name from d2000_5000 to Dddmmyyyy? [closed]

I am trying to change the name of a field by using Python code where the current name is in the format (e.g.) d2000_5000, and 5000 is the decimal year (0,5 y) added to 2000. So i think that this can ...
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
0answers
176 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
793 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
1answer
79 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
211 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
113 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
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 ...
1
vote
1answer
47 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 ...
3
votes
0answers
187 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 '...