Questions tagged [date]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
209 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-...
1
vote
2answers
725 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
846 views

Automatically adding date to attribute table in ArcGIS 10.3.1 for Desktop?

I am using ArcGIS 10.3.1 for Desktop. I am working on a polygon layer in GDB file and i want that every feature that have been created in the map will be the date of creation (date and datetime). I ...
1
vote
2answers
431 views

Create a raster with ranges from another raster

I have a raster that contains values ranging from 1-180. I am looking for a way to create a new raster where if the values of a cell in the original raster is between 1-10 the new raster cell gets the ...
1
vote
2answers
701 views

Entering date with arcpy.GetParameterAsText()?

I want to allow users to enter a date as a parameter through a dialog window in a toolbox script. I have obviously defined the field with a "Date" data type but something is wrong with the formatting....
1
vote
1answer
15 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 ...
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(...
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?
1
vote
1answer
71 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 ...
1
vote
1answer
209 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....
1
vote
1answer
220 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
115 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
1answer
96 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?
1
vote
2answers
43 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
638 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. ...
1
vote
2answers
814 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 ...
1
vote
1answer
267 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
1k views

Converting date field value returned by REST API to correct date? [closed]

I performed a query on this USGS feature service of Airport locations: Click for query And the value for the field LOADDATE is: LOADDATE: 1411380301000 However, when I pull the layer into ArcMap, ...
1
vote
1answer
911 views

Concatenate Multiple String Fields and Convert to Date field using ArcGIS Field Calculator?

I'm Working in Model builder using the calculate value tool. I have three columns - SignatureDay, SignatureMonth, SignatureYear - All three are string data types and all consist of just numbers for ...
1
vote
1answer
529 views

arcmap layer export as shapefile, in the dbf file the time value is missing

In arcmap, I export a layer as shapefile. After that I find from the dbf file, the editor tracking date-time columns (created_date, last_edited_date) value only contain the date value, The time value ...
1
vote
1answer
2k views

Using Field Calculator to Add a Set Amount of Time to Date Field

I wish to georeference several photos to a track created using a Garmin Oregon 450t, but the time recorded in the photos and the time recorded in the .GPX are not the same. The format for the date ...
1
vote
1answer
61 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
1answer
149 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
485 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 ...
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
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 ...
1
vote
1answer
349 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
1answer
94 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 ...
1
vote
1answer
81 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 ...
1
vote
1answer
551 views

Add attribute of type Date to shapefile using OGR

can anyone tell me how to add an attribute of type Date during a shapefile creation? For Integer works fine using the following code: Layer1.CreateField(ogr.FieldDefn('NumberIndv', ogr.OFTInteger)) ...
1
vote
1answer
361 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]'&...
1
vote
1answer
922 views

Format of Date/Time Field in Datasets for use in CartoDB Torque CAT

I have a Date/Time field in my data set on cartodb that is formatted as follows: 2016-02-09T10:30:00Z that is the value in the first row. The data type is set to 'date'. I want to use this field to ...
1
vote
2answers
147 views

Inputting BCE dates in CartoDB?

I am working on a mapping project which includes BCE dates, but I am having trouble getting CartoDB to understand them as dates. So far, the methods I have tried either give me a date in '69 or no ...
1
vote
1answer
258 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 ...
1
vote
1answer
459 views

Calculate date field using date variable and time attribute in a feature class

I have a string variable (fileDateString) with the date in this format: 20150404 In my feature class there is a text field with time in twenty-four hour UTC format. There is also 2 leading spaces ...
1
vote
1answer
257 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 ...
1
vote
1answer
245 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
2answers
2k views

Removing time from date field labeling in VBScript

I'm not at all experienced with writing VBScript for labeling purposes. Here is my code so far: Function FindLabel ( [Date_of_Birth] ) if not isnull ( [Date_of_Birth] ) then FindLabel = "...
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
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?" ...
1
vote
0answers
142 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
171 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 ...
1
vote
0answers
40 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
0answers
39 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
1answer
180 views

make Carto torque points change over time start from begin date and disappear at end date

First time use the torque function... I have variables: IDnumber,start_date, end_date, size, longitude, latitude. Anyone know how to make carto torque points change depends on different dates? I want ...
1
vote
0answers
246 views

Spatial AND temporal join between two point data sets [closed]

I was hoping I could get some pointers in how to approach this issue, which is tricky version of a spatial join. I have been searching and I can't find a particular solution to what I need. I have ...
1
vote
1answer
443 views

Geoserver WMS Time Support - Absolute Interval

as the title suggests, I am currently working with a wms provided by geoserver 2.8.x, with the focus being put on a time-attribute. The official documentation is really lacking details on how to ...
1
vote
0answers
375 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 ...