The equations actually look pretty good to me. Here are two slightly simplified statements you can try. These will both result in Date/Times, but should align.
Calc for left table:
DATETRUNC('month', [dtval Month])
Calc for right table:
Let me know if this still doesn't work.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
DATEPARSE('yyyyMM',[ListYYYYMM2]) <--- I'm getting "Unknown function Dateparse called". I'm using 10.5 is this function available?
This means that you're probably running a live connection, which doesn't allow for the Dateparse function. In place of the Dateparse function give this a try:
DATE(LEFT(STR(201704),4) + "-01-" + RIGHT(STR(201704),2))
I noticed two things in the original equation. First, we only used a 1 for the day instead of 01. Second, the DATE function wants the year to come first.
Give this a try and let me know if you're still having issues.
Wrap the DATEPARSE in a DATE() function. I think the left table is making a date and the right is making date/time, which is preventing them from matching. This should do it...
I appreciate the help. It seems like every different calc I try I'm getting different numbers, but all of them are slightly off of what the actuals are. I will try to keep playing around and see if I can see what is causing the mismatch.