5 Replies Latest reply on Jul 6, 2018 10:13 AM by Tushar More

    Date in string field

    jonathan kassak

      I have a data extract with date information in a string

      The string field, let’s call it “date” is displaying data

      2018-02-21 22:00:00.000

      My need is to display the date as:


      I tried using dataparse in a calculated field.

      Here is a formula I used:

      DATE(DATEPARSE('yyyy-mm-dd hh:MM:00.000',[Date]))

      Sometimes, the date appeared correctly but most often it did

      In the example, above I got the following result:

      12/21/2017, rather than 2/21/2018

      Requesting some help with the syntax or another way to do

      I’m using Tableau version 10.3.2