Date Format / Reformat to SQL ?

I am trying to transform a date from JSON to SQL Date. Am I supposed to use date format or date reformat? No matter what I seem to do, the result gets set to null.

Both of then should work

From the screenshot provided we cannot see the values passed into date format or date reformat functions.
It is difficult to understand what is going on:(

I even tried taking the date parts and sending them along.

For loading data into the database you have to make sure that it is on YYYY-MM-DD HH:MM.SS.FFF format (without leading or trailing spaces)
Your transformation is far too complicated you can Just use After and Before transformations to get the data you need
After => Before=>Date format

I started create a second transformation as you suggested. I noticed the values from the Json pairs don't go to the next transformation (transformation 4)

I even tried stripping away any formatting or lookups. Just passing the Json pieces to the next transformation. No luck.