Hi @creedsmith,
If you are happy to use linear interpolation to fill in the missing dates, then it would seem to me that turning dates into a serial number representation and then using Missing Values is a possible way to achieve this.
I have a component on the hub that I have just modified (as before it only accepted Local DateTime columns, but it will now accept a Local Date column too)
This can produce a “unix serial number” for the date, based on seconds since 1970-01-01. With this as a serial number, the Missing Values can then perform linear interpolation on it. Turning that into a Long , the standard node Unix Timestamp to Date&Time can convert the number back to give you interpolated dates:
Fix missing dates.knwf (59.2 KB)
To do this without the component, calculate the number of seconds since 1 Jan 1970 and multiply the result by -1, or take the abs() value using Math Formula, as follows:
