3 Replies Latest reply on Nov 2, 2016 11:38 AM by MichaelH H Branched to a new discussion.

    help to get date calculations

    MichaelH H

      Dear Tableau Community,

       

      I'm new in using tableau but really trying my best to create my calculating fields, for some I succeed but now I really need your help.

       

      I need a calculating field that will give me the November 30 date with current year (example today is year 2016 so I need to get the End Date as 11/30/2016 if now is year 2017 then I should get 11/30/2017

       

      I also attached the excel file that has my other queries and logic, please help me, I can create this date by using excel but unable to do this in tableau I'm always getting the error "expected type datetime found integer"

       

      Thank you very much.

       

      Kind regards,

      Michael