Hello, community,
I have a timestamp dimension in my data set in this format:
2022-05-18T03:01:24.281-03:00
I tried to directly change this dimension type in Tableau Prep, but the time was converted to 00:00:00 in all rows.
Then, I tried to use dateparse function ('yyyy-MM-dd hh.mm.ss AAA.aa', [timestamp dim]), but the results was null.
I also tried to extract only the date and time of the string using the function LEFT, and then convert to datetime but the time was converted to 00:00:00 again.
How can I do this conversion?
