Calculate End Date (Data Management)

Summary

Populates the values for a specified end date field with values calculated using the start date field specified. This tool is useful when the intervals between start date field values are not regular and you want to animate the feature class or table through time or some other value using the Animation toolbar.

Legacy:

This is a deprecated tool. This functionality has been replaced by the Calculate End Time tool that calculates end time for a given start time field.

Usage

• The table is first sorted by entity (unique value field) if this is specified, and then by time stamp. With the start date field sorted in ascending order, the end date of any row is the same as the start date of the next row.

• In order to use this tool the start date field must be able to be sorted in ascending order. To test this, open the attribute table for the feature class, right-click the field and click Sort Ascending. If the field cannot be sorted in ascending order, the field must be reformatted before using this tool.

• The end date field value for the last row will be the same as the start date field value.

Parameters

Dialog

Label	Explanation	Data Type
Input Table	The feature class or table for which an end date field is calculated based on the start date field specified.	Table View
Unique ID Fields (Optional)	The name of the field or fields that can be used to uniquely identify spatial entities. This field or these fields are used to first sort based on entity type if there is more than one entity. For instance, for a feature class representing population values per state over time, state name could be the unique value field (the entity). If population figures are per county, you would need to set county name and state name as the unique value fields, since some county names are the same for different states. If there is only one entity, this parameter can be ignored.	Field
Start Date Field	The field containing values that will be used to calculate values for the end date field. The start date field and the end date field must be of the same format.	Field
End Date Field	The field that will be populated with values based on the start date field specified. The start date field and the end date field must be of the same format.	Field

Derived Output

Label	Explanation	Data Type
Output Table		Table View

Python

arcpy.management.CalculateEndDate(Input_Table, {Unique_ID_Fields}, Start_Date_Field, End_Date_Field)

Name	Explanation	Data Type
Input_Table	The feature class or table for which an end date field is calculated based on the start date field specified.	Table View
Unique_ID_Fields [Unique_ID_Field,...] (Optional)	The name of the field or fields that can be used to uniquely identify spatial entities. This field or these fields are used to first sort based on entity type if there is more than one entity. For instance, for a feature class representing population values per state over time, state name could be the unique value field (the entity). If population figures are per county, you would need to set county name and state name as the unique value fields, since some county names are the same for different states. If there is only one entity, this parameter can be ignored.	Field
Start_Date_Field	The field containing values that will be used to calculate values for the end date field. The start date field and the end date field must be of the same format.	Field
End_Date_Field	The field that will be populated with values based on the start date field specified. The start date field and the end date field must be of the same format.	Field

Derived Output

Name	Explanation	Data Type
Output_Table		Table View

Code sample

CalculateEndDate (Python window)

import arcpy
arcpy.CalculateEndDate_management("C:/data/HistPop.shp", "State_FIP;County_FIP", "Start_Date", "End_Date")

CalculateEndDate (stand-alone script)

# Name: CalculateEndDate_Ex02.py
# Description: Calculate end date based on a start date field
# Requirements: None

# Import system modules
import arcpy

# Set local variables
inTable = "C:/Data/HistPop.shp"
uniqueIdFields = "State_FIP;County_FIP"
startDateField = "Start_Date"
endDateField = "End_Date"
 
# Execute CalculateEndDate
arcpy.CalculateEndDate_management(inTable, uniqueIdFields, startDateField, endDateField)

Environments

This tool does not use any geoprocessing environments.

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes