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
      field.

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

      2018-02-21 22:00:00.000

      My need is to display the date as:

      02/21/2018

      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
      not.

      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
      this.

      I’m using Tableau version 10.3.2