It does not seem like the Union Tool is in the right place. Just looking at the image, it's hard to tell for sure, but I'll bet those two rows that got pasted below "null" came from the join and everything else came from your input file to the Union Tool via input #1. If you are looking to see what values are shared in common then you want to Union (in this particular case) the 'L' and 'J' outputs of the Join Tool. This is because the 'L' output contains all data from your 'L' input (which in your case is the main input file) that didn't match your criteria, and the 'J' is everything that matches from both the input file and the text input your joining to.
If you still need the formula tool with Today's Date, that can be placed after the 'L' output as well before going into the Union Tool.
Edit: Adding a sample workflow as example, please provide more information about your specific needs if this does not work for you.
