It looks like your just missing a parenthesis after left:
Hey Anand, there's a free utility called Notepad++ that is great for writing code. Lot of features, but most important one I use is it's parentheses pairing in red (not bold). Here's the download site. (Credit where credit is due Joe Mako turned me onto this handy little program.)
that was my typo err...
here is the valid one...
I copied and pasted above...
Hello I Have a similar problem. All my data is like follows: 200710 . That is October 2007. How can I change to date in Tableau. Thanks in advance