3 Replies Latest reply on Feb 14, 2016 11:29 PM by Tableau kumar

    Date Values are Null

    Ariel Rosen

      Hi, this may be very basic but I have tried many solutions found on the forums that haven't worked out for me.

      I am trying to get Tableau to recognize the Date field from an excel file. Currently the date is in this format "Sun Jan 01 2014" and Tableau interprets it as a string, but trying to change the data type into Date just brings back nulls. I've tried splitting the fields and then adding them up in a new calculated field to include the date in MM/DD/YYYY format but that also brings back nulls. I have the desktop version of Tableau and I've tried using DateParse as well but that doesn't seem to work either, although I could be using it incorrectly.

       

      Any guidance would be much appreciated, thank you!