I know it doesn't follow my first path, nor does it identify why my first route failed, but it looks like I was able to get 100% results by adding onto my 2nd route. I used "First Characters" to grab the first 6, then converted to type number, then another new column appended an 01 to every line with data. Finally '''Date.From''' is reporting correctly on each line of data.