Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
72 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
2answers
655 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
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]'&...
2
votes
1answer
760 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
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
1answer
190 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
174 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
84 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
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 ...
2
votes
1answer
134 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
181 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
96 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
275 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
174 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
223 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
599 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
261 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
376 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
2k 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
69 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
147 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
80 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
251 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
131 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
713 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
120 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
197 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
79 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
79 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
123 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
615 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
327 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: ...
4
votes
2answers
840 views

Adding today's date into attribute table using QGIS Processing modeler?

I am looking for a way to use the Processing modeler to add a date field to an output dataset in QGIS 2.6.1 I have tried using the field calculator algorithm without success. (Also the advanced ...
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
1answer
88 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
188 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
849 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 ...
5
votes
2answers
696 views

Splitting vector file by date (year) but column containing dates in Day/Month/Year format?

I am using national accident data in QGIS and quite frankly the dataset is huge as it contains every recorded accident between 2005 and 2014. I've split datasets by field for a number of vector layers....
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 ...
2
votes
1answer
2k views

Querying featureLayer using date field and ArcGIS API for JavaScript?

I can query a featureLayer in my javascript map to only show features meeting criteria for normal attributes (strings/integers), as below for example featurelayer.setDefinitionExpression("status = 0")...
2
votes
1answer
52 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 ...
2
votes
1answer
2k views

Understanding Date Time Format output in ArcGIS REST API?

It looks like the output format for dates from the ArcGIS REST API at 10.1 is in ticks. Has this always been the case? Can it be changed at the server level or the request level?
6
votes
1answer
5k views

QGIS filter on date value [closed]

I would like to filter on a date value (show only attributes with a date later than 1-1-2000 for example). The field is of QDate type. But doing so I get the message: "Type mismatch or improper type ...
0
votes
1answer
400 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:...
4
votes
1answer
2k views

Why is arcpy.CalculateField_management() writing 1899-12-30 00:00:00 instead of expected date?

I'm using ArcGIS 10.3.1 for Desktop to test before writing an answer to Entering date with arcpy.GetParameterAsText()? I have written the test code below that I am running against a test feature class ...
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 = "...
4
votes
2answers
4k views

Importing CSV file with csvt data in QGIS (2.8) will not assign type “date” to fields

I have a dataset (in CSV) and am trying to add several fields with date information, so I can filter points based on this data and generate maps (in QGIS 2.8) which will form a chronological series. ...
3
votes
3answers
4k views

Remove time stamp from date field using field calculator

I'm trying to copy the dates from a field called InspectionDate (date data type) to new field called CompletedDate (date data type) but I don't want the time stamp to be copied over. How can I copy ...
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, ...