is you first field parsed as date time in tableau ?
Did you check this function from tableau ?
Returns a datetime that combines a date and a time. The date can be a date, datetime, or a string type. The time must be a datetime. This function is available only for MySQL connections.
MAKEDATETIME("1899-12-30", #07:59:00#) = #12/30/1899 7:59:00 AM#
MAKEDATETIME([Date], [Time]) = #1/1/2001 6:00:00 AM#
Will something like this work for you?
I have used two sheets per your date formats that I joined them with common dimension (ID was in my sample).
See attached file for more info. Hope it helps.
date from table name.twbx 17.3 KB
I just wanted to check back with you if any solution solution provided here answered your question or not. If it did, can you please mark as correct answer so that it is cleared from question board that needs to be answered as well as other users in future can benefit from it. If not, please feel free to ask for help. Thank you.