Skip to main content

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
  1. Nov 26, 2024, 12:37 PM

    @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

0/9000