I am connecting to oracle data base. Tableau recognizes field as string, while it is date time. When I convert it to date - it changes hours into days and minutes into months, which is completely nonsense. Can you tell me why and how to fix this? See screenshots attached.
1 answer
@Michał Magin
Hi, probably the best you can do is to manage it as string and then use DATEPARSE to create a calculated field:
DATEPARSE("yyyy-MM-dd hh:mm",[DATA_STARTU])If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador