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,