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.