We're integrating our Roads and Highways deployment with an external system. The external system does not like it when the FROM_DATE=TO_DATE, whether it be on historic or current routes.
Sometimes, to preserve internal events, I find myself making a "temporary edit". Perhaps I'll reassign a roadway to a fake ROUTE_ID while I sort out the edit upstream or downstream, then reassign the road to the actual ROUTE_ID.
We use the date the edit was made as the FROM_DATE, by simply pulling up the date picker in the R&H dialog and selecting "Today". The system provides a default of "8/22/2019 00:00:00". Since subsequent edits on the same ROUTE_ID will all have the same FROM_DATE, these types of temporary edits are creating historic routes where the FROM_DATE=TO_DATE.
It seems like the easiest way to address our issue is to use a date/time field instead of a date field. It looks like all Date fields in ArcGIS are also date-time fields, so we're pretty close to where we need to be. Is there a way to have the "Today" Roads and Highways buttons include the timestamp in the "Effective Date" field? Manually entering it ourselves is tedious and error prone, especially since our database is using UTC.
Thanks for reading!
Accepted Solutions
