4 Replies Latest reply on Nov 14, 2017 3:21 AM by ganesh kamath

    Confusion between date and month

    ganesh kamath

      Hello Friends,

       

      In one of the project I'm facing a problem with the date and month criteria.

      Tableau tool gets confused between the month and date (in case where the month and date is upto 12 . Foreg : 20171112 or 20170311) and its populating wrong output.

       

      Im creating a calculated field as : DATE(MID([DateField],7,2)+"-"+MID([DateField],5,2)+"-"+MID([DateField],1,4))

       

      attached screenshot for your reference.

       

      Request you help to sort out this issue.

       

      Thanks.