Full Outer join with two table : result error

[Anonymous]

Hello,

I am trying to full outer jointer two table with a common key which is a key ID.

But I am meeting this error message which I do not understand because my Key ID is not a date value : 

DataFormat.Error: We couldn't parse the input provided as a Date value.

Did you already met this message ? 

Thank you. 

[v-easonf-msft]

Hi, @Anonymous 

Can you show relevant screenshots?

You can also refer to these related threads.

DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a-Date 

same-column-but-date-is-not-recognized 

Best Regards,
Community Support Team _ Eason

[Carmichael]

What are the datatype of the two key columns you are trying to join on?  Can you share a screen shot?

[amitchandak]

@Anonymous , check one of the tables might have an issue with the Date columns.