Thanks that was it...
Looks so simple looking at it here 🙂
Now I have added some null checking and error rows redirects as well. Working like a charm.
This is part of the exercise for my MCSA 70-463 exam and the sample code simply wasn't working.
The sample code was simply loading it (trying to and failing actually) from YYYYDDD format into date field without any formatting.