TRY THIS ONCE
FIRST SPLIT , RIGHT CLIK ON first column and then use ", mention 2 splits
and then for F1-Split2 ,click custom split and then use # , ALL and then
F1-Split2-Split2 ,click and then split or custom split use : , then mention 3 or clik ok , then it is divided into 7 ,59,0 convert those three to whole number and combine using MAKETIME
split and convert
after split you need to convert then to time part into number and then do MAKETIME and then include this makedatetime(f1-split1,MAKETIME)
is this fine
Book1q.twbx 5.8 KB
I just mocked up some text data in the format based on your screenshot and it worked just fine:
However, there's an even easier solution using Tableau's DATETIME() function, which takes a datetime string as an argument and can read a number of different common date time formats:
If you really want to figure out what's failing with the DATEPARSE I'd suggest first of all doing two separate dateparses, like these:
Then if one or both of them is failing the problem might be due to extra spaces, so trying the dateparse with TRIM() wrapped around the date & time dimension would be next.
v9.3 workbook is attached.
datetime parsing.twbx 7.7 KB