Questions tagged [date]

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

Filter by
Sorted by
Tagged with
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
421 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:...
0
votes
1answer
74 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 ...
0
votes
1answer
137 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 ...
0
votes
1answer
37 views

Strange POSIXlt year result [closed]

When I write x <- c('2007-05-05', '2006-12-31') strptime(x, "%Y-%m-%d")$year I get the result [1] 107 106 I thought that POSIXlt started at 1970, but this appears to start at 1900?
0
votes
1answer
437 views

Cartodb: How to make dates appear in Torque time slider

I am trying to use my date column as a time-slider in my cartodb map. But it doesn't appear or seem to be an option. What am I doing wrong? Here's my map: Map Here's my data: Thanks.
0
votes
1answer
25 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
2answers
38 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 <= '...
0
votes
1answer
41 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
33 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 ...
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 ...
0
votes
1answer
81 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 ...
0
votes
1answer
854 views

QGIS filter by date in attribute table

I am trying to filter features within a shapefile for a specific date range. In the shapefile, one of the attributes is "date" and I would like to be able to filter it so it only shows a specific date ...
0
votes
1answer
334 views

Update Cursor from TEXT to DATE field

I have column that contains dates that are created from a numpy array to fc, since numpy doesn't handle date types I have had to create another field to update the rows. When using this script in the ...
0
votes
2answers
210 views

UpdateCursor not calculating the date

My UpdateCursor isn't working in arcpy. Here's my code: urows = arcpy.UpdateCursor(firstDatabase+ os.sep + "Temp") for urow in urows: urow.Import_Date = time.strftime("%d/%m/%Y") urow....
0
votes
1answer
32 views

recognising “any date” in symbology?

Could anyone tell me how to select a date in the Symbology > Categories > Value field to express symbology for any cells that contain a date rather than having to add every date as a field to define ...
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'...
0
votes
1answer
465 views

How to save time without date in shapefile's DATE filed using ArcGIS 10.2?

I am trying to save a time in a shapefile's DATE field (without a date, because shapefile can only store something one simultaneously - date or time). I use field calculator with PYTHON parser. I am ...
0
votes
2answers
1k views

Geodatabase add current date and time to attribute

Is it possible in Arcmap 10.0 to create a geodatabase feature class that has a date field which auto populates with the current date and time, every time a new feature is created? Is this possible ...
0
votes
1answer
17 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 ...
0
votes
1answer
63 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
28 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
0answers
44 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
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 ...
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-...
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 ...
0
votes
0answers
81 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 ...
0
votes
1answer
1k views

How to format an attribute of type esriFieldTypeDate from a FeatureSet Graphic

Hoping someone can tell me if I'm going about this wrong, but I'm executing a QueryTask / Query on a map service and getting back a FeatureSet as expected. Within the attributes of each Graphic, I ...
0
votes
0answers
238 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...
-1
votes
2answers
123 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 ...
-1
votes
1answer
534 views

Format difference between list of dates and specified date in R? [closed]

I want to determine the number of days between each of a list of dates and a specified date - here 1987-01-01. Looking at other examples and using some example data I write: Example<-as.Date(c("...