This seems easy. I am trying to map a field from a table to another based on a date field and a timestamp field. I think the issue I am having is in the formatting the mapping fields. Please see attached. Thanks for the help.
Ok, I think I figured it out. As I guessed it was a formatting issue. To match the 2 dates I converted both to numeric. For the timestamp, I used floor() to eliminate the fractional part