Questions tagged [date]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
623 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
817 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
410 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
694 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
37 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
70 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
157 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
194 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
95 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
89 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
613 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
763 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
261 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
905 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
527 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
127 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
402 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
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 ...
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
46 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
331 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
92 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
80 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
525 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
345 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
914 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
256 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
458 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
252 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
243 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
51 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
128 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
139 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
149 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
37 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
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
1answer
176 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
241 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
428 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
363 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
112 views

Need Help Creating Query Layer From Oracle For Past 365 Days [closed]

I have several Query layers that work fine for generic, long term date ranges such as: This shows all entries that have the previous YEAR in the date field. AND To_char(ds.calendar_date, 'YYYY') = ...
1
vote
0answers
83 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
201 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
1answer
405 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:...