ArcGIS Pro – How to Create Year, Month, and Day Columns in ArcGIS Pro 3

arcgis-prodatedatetime

Based on the sample data column below, what tool I can use in ArcGIS Pro 3 to create the Year, Month and Day columns in the attribute table?

The purpose is to then use these columns to create a space time cube.

Please note that I am not looking for a Python script based solution, as I know this can be easily done in R. I am looking for a tool or a model builder based solution` (if necessary).

Sample data:

1/27/2021 4:48:45 PM
12/30/2020 8:59:58 PM
12/24/2020 9:18:21 PM
1/22/2021 10:38:24 PM
12/18/2020 9:12:52 AM
1/28/2021 9:26:15 AM

Best Answer

Create new fields in your field designer for each field, year, month, and day. Then use the field calculator to calculate each value using the python interpreter, respectively. !datefield!.year, !datefield!.month, and !datefield!.day.

Related Solutions

arcgis-pro – How to Get Basic Statistics from a Feature Server and Display in ArcGIS JavaScript

Using the ArcGIS API for JavaScript, once the layer has loaded, you can use a "group by" query on the layer to get the summary statistics that you want. Then display/format the table/chart as you wish.

Snippet:

  gfPunkt.when(() => {
    const statsQuery = gfPunkt.createQuery();
    // create a query for both Count and Hectares
    statsQuery.outStatistics = [
      {
        onStatisticField: "hectare",
        outStatisticFieldName: "Counts",
        statisticType: "count"
      },
      {
        onStatisticField: "hectare",
        outStatisticFieldName: "Hectares",
        statisticType: "sum"
      }
    ];
    // group by year
    statsQuery.groupByFieldsForStatistics = ["year"];
    // return the results ordered by year
    statsQuery.orderByFields = "year";
    gfPunkt.queryFeatures(statsQuery).then(displayResults);
  });

Full example code at https://codepen.io/bsvensson/pen/WNZQoqO

Resources:

ArcGIS Pro DateTime – Merge Date and Time Columns to Combined Date Column

Try this code with the Calculate Field function where the output field is of type date:

Here is the code:

var rec_time = $feature.survey_time;
var str_len = count(rec_time);

IIF(str_len ==7,rec_time = concatenate('0',rec_time),0);

var isAM = IIF(right(rec_time,2)=='AM',true,false);
var hours = ceil(left(rec_time,2),0);
var minutes = ceil(mid(rec_time,3,2),0);

IIF ((isAM==false) && (hours !=12),hours=hours+12, 0);
IIF ((isAM) && (hours ==12),hours=0, 0);

var hours_in_minutes = hours * 60;

var total_minutes = hours_in_minutes+minutes;
dateadd($feature.survey_date,total_minutes,'minutes');

Best Answer

Related Solutions

arcgis-pro – How to Get Basic Statistics from a Feature Server and Display in ArcGIS JavaScript

ArcGIS Pro DateTime – Merge Date and Time Columns to Combined Date Column

Related Question