Questions tagged [date]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
700 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
2k 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
63 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....
3
votes
2answers
786 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 ...
3
votes
1answer
418 views

Reducing number of points, keeping most recent data within given distance, using QGIS?

I have a HUGE dataset of points that were collected along a route. The data may change daily, and the most recent data is the most important. What I would like to do is take only 1 point from a given ...
1
vote
1answer
139 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
168 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
93 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.
1
vote
1answer
294 views

Incorrect time displaying in ArcGIS API for JavaScript popup template?

I'm creating a web map that is updated a few times a day showing voltage readings from meters on our distribution network. This layer has a field called ReadTime, and the data type is Date. The date ...
1
vote
1answer
269 views

Thematic map using date field in ArcGIS [duplicate]

I need to create a thematic map for time intervals (ex. 1/1/1920-31/12/1929). To every polygon corresponds a date (from a date field) and I need them to be coloured depending in which interval they ...
2
votes
1answer
179 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
212 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 ...
0
votes
2answers
66 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'...
3
votes
1answer
458 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 ...
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 ...
1
vote
1answer
96 views

Creating date picker for CartoDB map?

I am working with data that I need to be able to display by day gathered, and it's gathered over a period of years. I would like the user to be able to select a date from a calendar-type picker, and ...
2
votes
1answer
2k 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
183 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
1k 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
400 views

use date(now) equivalent in mapserver

I want to use present year in a CLASS in a map file. I managed to write permanent expressions like: LAYER CLASSITEM "YEAR" ... CLASS NAME "Previous years" EXPRESSION ('[YEAR]'&...
2
votes
1answer
780 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 ...
1
vote
1answer
248 views

Coloring polygon based on date using TileMill/CartoDB?

How would you color a polygon/line/dot based on a date? The colors would be a pre-set list. I need the area to update its color based on the current (or given) date. I would be using tilemill or ...
1
vote
1answer
264 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 ...
4
votes
1answer
266 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
150 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
1answer
50 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
1answer
135 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 ...
3
votes
0answers
200 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 '...
4
votes
0answers
132 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
344 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
229 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
250 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 ...
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-...
8
votes
1answer
792 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
350 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="...
6
votes
2answers
466 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 ...
2
votes
2answers
3k 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?
0
votes
0answers
71 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
211 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
90 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 ...
1
vote
1answer
272 views

Select by attribute using date field values two days before machine date of ArcGIS for Desktop?

I have a date field within a file geodatabase of ArcGIS 10.2 for Desktop that I am accessing using ArcMap. An example of a value in this field: 19/11/2014 08:49:56 I want to select all rows that the ...
3
votes
1answer
141 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 ...
1
vote
2answers
1k 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
votes
2answers
135 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 ...
2
votes
1answer
231 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 ...
0
votes
0answers
89 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 ...
1
vote
1answer
88 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 ...
0
votes
1answer
168 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
979 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
415 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: ...