Interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool

RyanBohan — Fri, 07 Jan 2022 17:53:05 GMT

I would love to easily be able to interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool.

The Fill Missing Values tool works great for things like missing pipe diameters. I can easily run the tool and fill in missing values based on what is nearby.

However the tool does not seem to be able to fill in dates. Currently I have a rather janky work around. Converting dates to numbers and then back.

Convert date to a number in a new field using the Convert Time tool yyyyMMdd
- 12/15/2004 --> 20041215
Use the Fill in Missing Values tool on the "dates" now stored as a number
In a field calculation return dates formatted as date
- Do some arcade to get 20041215 into a format the Date function likes "yyyy,MM,dd"
  - Be sure to subtract one form the months field
- 20041215 --> 2004,11,15
- return Date(2004,12,15)
- This will return the date(s) including those filling in with the Fill in Missing Values tool
Use the Convert Time Zone, if necessary

Would love to just be able to run the Fill Missing Values tool and fill in the missing dates

Re: Interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool

BrittanyBurson — Tue, 04 Jan 2022 19:20:53 GMT

Upvote.

idea Interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool in ArcGIS Pro Ideas

Interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool

Re: Interpolate missing Date(s) with the Fill Missing Values (Space Time Pattern Mining) Tool