1 of 1 people found this helpful
You could combine both of these into a single calculated field and change that to a datetime by right clicking on it (IE: Concatenate the values)
Alternatively, MAKEDATETIME would work: Date Functions
Thanks for the quick response. I ended up concatenated the fields even though I was ultimately trying to avoid that. I'll just have to live with that for now.
BTW, I tried to use MAKETIME and MAKEDATETIME but Tableau is saying those are unknown functions. I did this:
MAKETIME(LEFT(Timecompleted, 2), MID([Timecompleted],4,2), RIGHT([Timecompleted],2))
Ah, yah - those functions don't work with certain databases.
You can sometimes get around it with an extract.
Cool, thanks for the help.