Comparison between String and Column Value not working

Easiest way will probably be to Merge the 2 tables on Date to return the fields you need

Hi Walt1010 ,

HotChilli Thank you for your concern about this case! I agree with you.
Have you solved your problem? If not, what HotChilli said is as below, you can follow these steps:
Here is my sample data:

First, merge queries:

The output is as below:

Expand the table:

Then add custom columns:

Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.