Questions tagged [date]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
693 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
835 views

Getting date from excel with xlrd as text in textelement?

when I run the script below in arcmap in the python window the date gets print however I get the following error:Parsing error SyntaxError: invalid syntax (line 19) the date isn't showing as text in ...
1
vote
1answer
431 views

Changing format of dates in ArcGIS 10.2 table

I am working with a table in ArcGIS 10.2 with over 500 entries containing dates. I am looking for a fast solution to transform the format of dates, from dd/mm/yyyy to mm/dd/yyyy. So if a date is 10/...
4
votes
1answer
758 views

Why does shapefile's dbf convert YYYY date to YY-format?

I save date from database's timestamp to shapefile date attribute. For example, I took from database [2031,10,31] and set it to '31.10.2031' at shapefile using python's shapefile.py as sh: self.sh....
6
votes
3answers
6k views

Date-format conversion

I'm using Time Manager and QGIS 1.8.0 and I am stuck at date-format conversion. Time Manager needs Gregorian format YYYY-MM-DD HH:MM:SS.ssssss in text field and I have thousands of records in "month/...
2
votes
1answer
870 views

Can I automatically save datetime for every entry in my spatialite tabel? [duplicate]

I'm using QGIS and SpatiaLite. Is it possible to store date and time in a field "datetime" for every entry automatically - maybe with some python code? Already existing datetime should not be updated.
0
votes
1answer
332 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 ...
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. ...
5
votes
1answer
798 views

QGIS Conversion to_date doesn't work

I have a table with one of the fields named Date_Time. The features are like 21-5-2016 14:47:00 (field type is string). I want to extract the dates and add them to a new field with the Conversion ...
1
vote
1answer
200 views

MapBasic subtract date columns

Is it possible to create a MapBasic SQL command to subtract one date column from another and get the number of days between the two (positive or negative values)? I have found the following process ...
3
votes
1answer
291 views

ogr2ogr, force DATE cast on a SQL request

I am trying to complete column null values on a .shp file with one default value. My column has a DATE type. Files schema : "COLUMN_NAME TYPE(SIZE)" Input (with null values) : CLICHE VARCHAR(80) | ...
1
vote
0answers
362 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
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
2answers
761 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 ...
2
votes
1answer
283 views

Deleting rows using UpdateCursor and date field

I have a large script, in which a part of it wants to check whether a shapefile has attributes in the "Valid_From" date field. If they match the date variables already created, these need to be ...
3
votes
0answers
73 views

Query out a specific date regardless of the time, using python [closed]

Problem: I have a feature class with an attribute table with a field called Edited_Date and its data in the field is as follows: 4/8/2015 10:00:00 PM. I want to select all records that are Edited_Date ...
0
votes
1answer
825 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 ...
2
votes
1answer
221 views

Definition Query to find next date value in ArcSDE attribute table?

I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one ...
4
votes
1answer
733 views

Dynamically style geoserver layer with timestamp column --> age of entry

I have a a postgis table with point geometries and a timestamp column, which has the information when the point was created. This table is already loaded as a layer into geoserver. So now in ...
4
votes
1answer
102 views

Date Formatting Mess

I am trying to format a date field that underwent incorrect importation. The result was that the date format became coded in a way i am unsure of. Is there a simple way using the field calculator ...
-1
votes
1answer
514 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("...
0
votes
1answer
36 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?
1
vote
1answer
814 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
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 ...
2
votes
1answer
330 views

Converting time field omitting time and returning null values?

I have a time field in my shapefile that is formatted as HH:mm:ss.s It is a text field, and I want to convert it to a date so I can calculate time elapsed across rows (if there's a better way to do ...
12
votes
7answers
17k views

Selecting by month in date/time field using ArcGIS Desktop?

I would like to select by a specific month from my date/time field in ArcGIS, and just can't seem to find a statement that will work. I have multiple years and multiple days, but want to filter those ...
9
votes
2answers
7k views

Calculating Date Field with today's date from datetime.date.today()?

I'm working on part of tool that will use arcpy.CalculateField_management to add the current date to the attribut table. I've wandered far and wide on the interwebs and can't seem to find the ...
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
1answer
524 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
0answers
240 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
427 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 ...
2
votes
1answer
290 views

Change Date to Future Date in Map Title Using Python or Dynamic Text [duplicate]

I'm trying to create a dynamic map title in ArcMap that updates based on current day + 2 days. For example, if I run the code on the 20th of a given month, the title should update to show the 22nd. ...
4
votes
2answers
596 views

How to create in QGIS shapefile a field that automatically returns the current date

I'm digitizing a shapefile in QGIS and I need to create a field that returns automatically the current date.
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
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/...
5
votes
1answer
2k views

How to Query Layer using ArcGIS REST Services for Records with Date Closed Field less than 24 hours ago?

I am current trying to do layer definitions on a map and so I am trying to filter some records via a time factor so i was writing in the Where field DATE_CLOSED_ON > (CURRENT_TIME - 24) and ...
5
votes
1answer
1k views

Problem viewing SQL 2008 “Date” field

I am using ArcMap Basic 10.1 SP1 and I'm connected to a permitting database stored in a SQL Server 2008 R2 database. I am trying to pull the tabular data over into my ArcGIS Desktop Project so that I ...
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 ...
11
votes
3answers
4k views

Can ArcGIS for Desktop auto populate Date Field with current date/time when feature is created?

I am using Arc Desktop 10.3.1 in a versioned environment. In the geodatabase for the service requests there is a field called Date Notified. I would like this field to be auto-populated with the ...
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') = ...
3
votes
1answer
421 views

Landsat 8 images acquisition_date

I need to know the exact date of image acquisition for NDVI purpose, the date on image name is " LC80920852014222LGN00" is in Julian date, but in meta data it says"acquisition_date>2014-08-10" , I ...
3
votes
2answers
430 views

Using ArcGIS Desktop field calculator (python) to parse date

I'm trying to parse a datetime field using python (but have never used python for it before). I have a field that contains a valid date, but not a valid time... and other fields that have valid hour ...
1
vote
1answer
647 views

Changing Date Format via Field Calculator of ArcMap?

I'm trying to find a function in the Field Calculator (preferably in VB Script) that can add numbers into a field that already has data. I have year data ranging from the 1960s to 2014 in string ...
0
votes
2answers
206 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....
2
votes
1answer
820 views

Finding the date of acquisition of Google maps in QGIS

How do i find the date of acquisition of the Google map on QGIS? Please help.
3
votes
1answer
52 views

Can ArcGIS recognize an incomplete date?

I have a string field that I want to convert into a date field. The problem is that some dates are incomplete (ex: "-/-/1967"; "1/2/-"). So is it possible to have in the same date field complete dates ...
4
votes
1answer
9k views

Applying a definition query to date field for feature in file geodatabase

Is it possible to apply a definition query to show data for today, yesterday and two days ago for a field where the data type is 'Date'? I have a script that downloads MODIS fire data and wish to ...
2
votes
3answers
937 views

Field Type Date invalid when run in Python, but not in Model?

Using ArcGIS Desktop Advanced 10.1 and PyScripter When running the arcpy.FeatureClassToFeatureClass_conversion, I get the error that the field type of Date is not valid. However, when running this ...
6
votes
2answers
525 views

Calculating Quarter (Q1, Q2, etc) using Date field in ArcMap Field Calculator?

I am using ArcMap 10.0 and making a map where I symbolize on annual quarter (i.e. Q1 2013, Q2 2013, and so on by quarter through 2015). If a date field contains this: 01/15/2013, and I wanted to ...
2
votes
1answer
73 views

Managing multiple dates in single column of shapefile using ArcGIS Desktop?

I have data example an organizations, which consists sl.no, name of organization, facility type, latitude, longitude starting date of facility.My problem is for particular facility i had two or more ...