Never mind folks.... It was easy
YEAR ([Orders$].[Order Date]) = 2010
Somehow, when I used it for the first time, it did not work. After recreating everything, it just worked fine!!!!
Thanks for following up here. You may also find that using Data Source Filters gives you an easy way to express filter criteria that must always be enforced, so consider using that feature if you find you have to regularly create or update your filter conditions. Finally, once you have switched to using a data source filter then you will no longer need to use Custom SQL, and can instead define your connection using the Single-table or Multiple-tables options.
+1 Data Source Filters were a life changer for this guy.
Thanks Robert. I am learning Tableau through video tutorials and wanted to replicate a scneario with custom SQL. I will definitely keep in mind the method that you have mentioned and will learn more about it.