<div>
Change the name of the column. &nbsp;I realize this is going to be an unpopular answer, but it's the right one.&nbsp; Alternately, do the math outside of the DATEADD.
</div>


<div>
<pre><code class="code-1 nolinks" id="code-20-43288329-1"><span>select dateadd(year,-1,getdate())</span>
</code></pre>
returns<br />
2020-05-14 08:25:10.450
</div>


<div>
@Paul, can't do that, will have to use a fixed date<br><br>@David if I put that in my view I get:<br>select dateadd(<strong>MYTABLE</strong>.year,-1,getdate()) <br><br><br>
</div>


<div>
'Range' implies a start and end date, and your formulas only return a single value. &nbsp;Please define with sample data exactly what you are trying to pull off here.&nbsp;
</div>


<div>
@Jim, if I put in &gt;03/02/2020 I get a years worth of data<br><br>If I put in my view:&nbsp;<pre><code class="code-1 nolinks" id="code-20-43288370-1"><span>SELECT ... From ... WHERE date &gt; DATEADD(year,-1,GETDATE())</span>
</code></pre>Because one of the table columns is 'Year' it changes to:<br><br><pre><code class="code-1 nolinks" id="code-20-43288370-2"><span>SELECT ... From ... WHERE date &gt; DATEADD(<strong>MYTABLE</strong>.year,-1,GETDATE())</span>
</code></pre>Which does not work.<br><br>Going to have to put up with a fixed date I think.<br><br>
</div>


IT Technical

HKFuey

<div>
That doesn't make sense. &nbsp;SQL Server should never treat that entry as a variable / column name, since they are not allowed there, only constants.<br><br>In other words, "Because one of the table columns is 'Year' it changes to: MYTABLE.year". &nbsp;No, it doesn't, at least not SQL Server.<br><br>SQL Server would never expect to see a column name there. &nbsp;Which dbms is doing this? &nbsp;Oracle? &nbsp;MySQL?<br><br><br>
</div>


<div>
@Jim, believe it or not I also have a column called 'Month' :)<br><br>I will try this: SELECT ... From ... WHERE date &gt; DATEADD(day, -365, GETDATE())<br><br>@Scott this is a SQL 2012 view and looks like this:<br><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiQAAABdCAYAAACVQX1QAAANyUlEQVR4Ae2d3W3jsBJGVdBtIC7nAnEzFzBSwvYQIK/bRoB9WmwDKcAAL0h6oiFFWpIlSnLmBDD0Rw7Jwy/6JpS82zl+IAABCEAAAhCAwM4Eup3bp3kIQAACEIAABCDgSEgQAQQgAAEIQAACuxMgIdl9CugABCAAAQhAAAIkJGgAAhCAAAQgAIHdCZCQ7D4FdAACEIAABCAAARISNAABCEAAAhCAwO4ESEh2nwI6AAEIQAACEIAACQkagAAEIAABCEBgdwIkJLtPAR2AAAQgAAEIQICEBA1AAAIQgAAEILA7ARKS3aeADkAAAhCAAAQgQEKCBiAAAQhAAAIQ2J0ACcnuU0AHIAABCEAAAhDofv/+7fjAAA2gATSABtAAGthTA92/f/8cHxigATSABtAAGkADe2qARzaskkEAAhCAAAQgsDsBVkhYIWKFDA2gATSABtDA7hogIUGEu4twzyVC2maJGg2gATRwDA10v379cnxggAbQABpAA2gADeypge7v37+ODwzQABpAA2gADaCBPTXQXa9Xx2d9BjKpsF2fLUxhigbQwE/WgFX/ICFplJBZFdRPvkkwNkwQDaCBLTRg1T9ISEhIWCFrpIEtbly0gUGigZ+nARISbsqrGrNVQXFz/Hk3R+aUOUUD22rAqn+wQtIoEbMqKG5c29644A1vNPDzNGDVP7qu61zXvbr3Fsb8/upifN9G514unzNWId7da/fiLp/PKba6oPy4Ig9hE7h8XtzL93ife+zcIJ9Ts8wb84YGjqGBun/c+rfIW48xxpLW4grJ58Vd3ud2csQ0AzCdUHy6y8ucpGQkfosEasWYdUFNGZcuo/fnzhHlS6LnHLpAA2jgyBqo+8fVXRd763HnfsEjm3tGGZOP1zzJCasAU1dj7sU/LlAReV1QU8aly+j9449bxs+WuUIDaAANPKaBun+s4a2P9WmLuRwmJCFp6B8p9ElFNMbX15fkMUx47PD6nj6KqSYeHqasmuh4tyRFtf1yuaSPbNS1/hFTIcaKqxxLJqAuqFqCoc/Lvt/2c9EJ5ydjsYQjdY9782BumBs00EYDVf941FsP4otjegnvkKRJR+e+j8PgdQKhH7mIaRYmxNd7ubjPAQSd3UWz7d8ricfS9ufFJz66bdmPS1axXh6j0JdBH7YpUxXUNfZZ3h/x2zhmf17GWNv3fdfXnoPFmAi5vo0m4QxnNPAcGqj6x0Pe+hxj9trsriHpuJli2E8fqby/lgzTDzAzRm38hTjxF2G4QvL90uoAtIp/66M28bhaoMro9g+wXxVUlZseS23/6mS+nokFN8HnuSEwV8wVGthfA1X/eMRbD+CHUzUVHtmE1Qj/OKAw2IcSkqteCVGTm8TXpnsz2mRVRV1P6ql4VXPXZfbZrwqq2mc13qSMPi8JSZo0xsnOyj2RCKeKlXL7aBnucEcD22qg7h8PeOsTeUF3vSUP+hGIPDZJE5Tc8PLjbMLCm8DaOH35e4984nVpe/jIRteVtkb6sONE1AVV67M+X9v34/bXnosFNzPRK1u0gAbQwLgG6v4h37KZ661TXgcY71fruYv/Dom8LOkNPKxGyIuUMgjfUW2SseN+9SQ8OtD1dRKQfVdako04qGG8+HWmGPP+S62ds/PI5uoGnJM5Oj6L1iIm/v43EuaAOUAD62ngbkLiPXaWt2qvre2v1/clOhh+y0YnFOyn3x6awWNUUDNiLZlg6h7jF415YB7QABqYqgGr/kFC0igxsCqoqb9wlOPmjAbQABooa8Cqf5CQkJA8vArEzaR8M4ELXNAAGliiARKSRsa8ZFKeua5VQT3znNF3TAQNoIEjaMCqf7BC0igRsyqoI/wy0wdMBQ2ggWfWgFX/ICEhIeGRTSMNPPMNkb5j6GhgPw2YTUhk4Gz/OhjAAA2gATSABtDAPhrovr6+HJ/1Gfznv/9zfGCABtAAGkADj2jAoi93jp8mBLwA+YEABCAAAQjMJWDVP0hI5iplYnmrgpqIh2IQgAAEIFAhYNU/SEgqglh62qqglnKj/jEI+P8Sgh8IQGAfAlb9g7tOI71ZFVQjnITdmAAJycbAaQ4CioBV/yAhUSJYc9eqoNZkSKz9CJCQ7MeeliFg1T9ISBppfz1BfbhzJ//7ctye3v4Ue/1x7lx3/kiuhXNZfW82McYwdlbdlWI6N6yX9mnseuzin7fToL9J57c6+Di7rju7lFzW+J83d9IcT28uzsJwrJ7hXO4pv77tEv+5sfWcCnMfQ7eZH5OQ9HPAHgS2JrCef2zd82XtkZAs41etvZ6gvOGdXJ+D3AxQu4zvhTfM09mdT7qs7l4ex18rnVN1qjHzenmfxq5Lf8XUVZub7v5xbyefxJ3d+V5CEpKRlOvHWRKYfKz5AErX83P+eJhMrj6nYT6FuR+7HlN6TEKSzyPHENiOwHr+sV2f12iJhGQNioUY9wXlb/5iaIXKyancvG5mnhmo/8vX/8Ur2yREOCjEGUlIJJZs+5iFWMG0ZUxj133+FPvbx9xzz/dX+p73IyYtef7XlyqMtb9YSfoKdRJ+MYAwkm0SNhwU4tyZ00EcvzKkB6aOSUiGtDkDga0I3PePrXqxfTskJI2YjwvKm0nhr+JBf0qmk5uk+us2+StYByvFKZ2TOvdilurpPo1dV7Gdrndr2xujPBIJRi2PrPqkIXls8W2qsd3z+TT+CEaGGba+Xh87uVRIFJLrdxKAWK7EonQu56AYrTKnKp4MII+rjklIBBJbCGxPYNw/tu/TFi2SkDSiPFlQ4f2Fzn176qA/E8xLGYkLBq+X4iVgKY4/J2bvt8qU78YsxdKGOuW6akv9Ze5765ONyCOL83FO3nuII9Nl/H76boSM/v7W11P90YUTDnFlx5t19/0YLbYZz2UMQxzdPwlcOqf55Y+0CsnE3dilOS2NMT/XH5OQyFyxhcD2BCb7x/Zda9oiCUkjvNMFFY0oSQaSPtXMq0868qV4f5wsxYd4pTilc7Hx+zFL9bRpTrmuEwBfXo4/3Lm4OnIzWcncboncMDnouSQYfWLxnXxJW1JCty/nbttQr1Re2imNVccoXS+d0/yGj7SWz2lpjGmbOpklIdFzyD4EtiUw3T+27Vfr1khIGhEeF5QkImJstY4UzCsxSX9d/0Us+/dMVNoqxA6XxmIW6g36lI1rcD3tnyRAsg3dSOpIn/N3aLSpFvqlqtV3fb20P33ZUkx9Tu/3tfq90vXCuWSs/rrMo97mfSzEqT5C8mVL9fW5vgwJST+D7EFgawLj/rF1j7Zpj4SkEef7gtImOtaB3HT8sTzSCM83+vctvkPFZEcWE+LpPI4/Wzo3JWZeL+vTIG5+vTB+b8iDbwnFevrrqWEsg3dMJPnJ+/UNZGTH19PGnBYPqxPJdd2O3k/rxaPS9fycP248p6VHeYG5fOsmfUxEQlKaS85BYBsC9/1jmz7s0QoJSSPq6wkqmlV8NOH/WhbzjR3P//0IGc5wiT83QV8yjx3fvxiPmddL+zSMm18fPpIIvSn8Oyrhq696tSBkWTHhCkySJCYbo05cBExx6+uphKRUL3lEpN9TyVnoa8I4H39eJ70+zl8GkY03nM5j9/1JVp9C1/iWjZBkC4EjEVjPP440qvG+kJCMM3qohFVBTYaV/3UeFmbUKsHkQPWC/cux9TKlK4/WK8U61LmEeb5KlR6zQnKomaMzxghY9Q8SkkZCtyqoOTiTVZzELOdEqZX1KwVq1aNWbHD+0XqDQIc8Icx90qVffM6PSUgOOX10yggBq/5BQtJI4FYFNR+nPH5JH1vMj0ONNQmQkKxJk1gQmEfAqn+QkMzTyeTSVgU1GRAFIQABCECgSMCqf5CQFOWw/KRVQS0nRwQIQAACtglY9Q8Skka6tyqoRjgJCwEIQMAMAav+QULSSOJWBdUIJ2EhAAEImCFg1T9ISBpJ3KqgGuEkLAQgAAEzBKz6R/f19eX4rM/AC4oPDNAAGkADaOARDVj0ZVZIGuXcXkz8QAACEIAABOYSsOofJCRzlTKxvFVBTcRDMQhAAAIQqBCw6h8kJBVBLD1tVVBLuVEfAhCAgHUCVv2DhKSR8q0KqhFOwkIAAhAwQ8Cqf5CQNJK4VUE1wklYCEAAAmYIWPUPEpJGErcqqEY4CQsBCEDADAGr/kFC0kjiVgXVCCdhIQABCJghYNU/SEgaSdyqoBrhJCwEIAABMwSs+gcJSSOJWxVUI5yEhQAEIGCGgFX/ICFpJHGrgmqEk7AQgAAEzBCw6h8kJI0kblVQjXASFgIQgIAZAlb9g4SkkcStCqoRTsJCAAIQMEPAqn+QkDSSuFVBNcJJWAhAAAJmCFj1DxKSRhK3KqhGOAkLAQhAwAwBq/5BQtJI4lYF1QgnYSEAAQiYIWDVP0hIGkncqqAa4SQsBCAAATMErPoHCUkjiVsVVCOchIUABCBghoBV/yAhaSRxq4JqhJOwEIAABMwQsOofJCSNJG5VUI1wEhYCEICAGQJW/YOEpJHErQqqEU7CQgACEDBDwKp/kJA0krhVQTXCSVgIQAACZghY9Q8SkkYStyqoRjgJCwEIQMAMAav+0fmB84EBGkADaAANoAE0sKcGWCFplHP7SeUHAhCAAAQgMJeAVf8gIZmrlInlrQpqIh6KQQACEIBAhYBV/yAhqQhi6WmrglrKjfoQgAAErBOw6h8kJI2Ub1VQjXASFgIQgIAZAlb94//63MYBdSvGvwAAAABJRU5ErkJggg==" class="fr-fic fr-dib">Until you tab out, then it adds the table name:<br><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiQAAAA7CAYAAABL7JEXAAAON0lEQVR4Ae1dUY7bOhL0gfYC8XEWGF9mgWCOkDsMMDfYt58vnwHmI2+QC8wBBtCiSdeo2GpKsi3JklwGHJLdzWazWCJbkpMc/vv370ZfYSAOiAPigDggDogD9+TA4Z6Da2yRXxwQB8QBcUAcEAeMA0pI9IRIT8jEAXFAHBAHxIG7c0AJiUh4dxLq7kh3R+KAOCAOiANfCcmfP38afYWBOCAOiAPigDiwbQ40G/18JSQ/fvxo9BUG4oA4IA6IA+LAtjmw0Xyk/Q3J+/t7o68wEAfEAXFAHBAHts2BzSckn5+fTe0Lctb0ktexEzbCRhwQB8QBcWBJDigh6UlollwIjaULXxwQB8QBceCROaCERAlJ9QnTI18YmrsOBnFAHBAHluWAEhIlJEpIxAFxQBwQB8SBu3NACYlIeHcS6i5k2bsQ4S28xQFxYI0ceNCE5KV5OhyaA32/ff/VfP763nw7fGu+/zKymg3qIu8ayauYxEtxQBwQB/bDgQdOSIaSDU5IuL6fxdeFrLUUB8QBcUAcWAsHlJBUX9lwEsJ1kXct5FUc4qI4IA6IA/vhgBKSIiHhxAN1K+n1ztNL/s1Fer0D+VPzkvzkPk9P35rDAbL9kEUXvtZSHBAHxAFxYC4OPHBCgmQil08vRjIkIX11r/tsPl+emvQblNT/cK6LtHORVn7FLXFAHBAH9seBB05Iot+QjExIiqcj58QmPTnh/vsjizYArak4IA6IA+LAXBxQQjL4ysbI5xKNlJBEr2ScXeFbJJ6LxPIrbokD4oA4sH0OKCEpkgZOKGp1W3TTRa9muM/2yaELXGsoDogD4oA4sBQHlJCMSkg+m5cnfjXzef43S+h3KHplo39greCSNrGlNjGNI66JA/vgwIMmJPtYPF2EWkdxQBwQB8SBvXBACYnuavVkQxwQB8QBcUAcuDsHlJCIhHcn4V6ye81Dd6rigDggDlzPASUkSkiUkIgD4oA4IA6IA3fngBISkfDuJNQdxfV3FMJO2IkD4sBeOKCERAmJEhJxQBwQB8QBceDuHNh8QvL+/t7oKwzEAXHgUTlw4P9r63DQfqgzYbMc2GxC8tffvxv7fnx86CsMxIEH5QAO4zH7gNmyHdqRj0jGfZeoIz6MhTZiG1Oir0qdE1vgwHYTkp+/m79+/u6N3xZAHyEgBPaBwJgDmG1s1tZG6etsy3W2Zzn6Q58c0xhoo2R77sNy1FHCztq3fuEL8agUAkJgHgQOlowoIZkHXHkVAmtC4NqD2eZwbd819rtlPmtaT8UiBPaGgBKSmVcUG7INg7qVvg0d5ChZnjrpDyFwBQLg0VSlheB9ISwvr7UjH2w7pGfbvvqlcfX5go5jg3+VQkAI3IaAEpLb8Kv2xsY1ZWmDwR/qCMDkXgbd1CXHMDQm4uIYuD/X4SvqAx38RDaRDPYqW+4A82tKrMPYvpfaj/W7tB3Pg7nEcbBcdSEgBC5HQAnJ5ZgN9uBNaom6BcTjoI3S66IJmA1/0Ac+UELOJfqx7NL6FD7Gjsljob6V0uZ46WcsLmPsbGy241hYfk3d+77Gx5x9EJ8v/ZiMiepCQAiMR+Dw189/Gvv2ffSj1j50ujq/Qd27bRHWYkD0fXrT9fmo9Z1bXovJy9FGGcXFOqvXPsCipp9DzmMidowT6WCzttJijmLy8qjtZZGfuWU+hlrb5PaxeKIPx8n6mj3bqC4E9ozAHRKS1+bkfvl+fH4LMX49HZrD6bXQJZnrbxdy9tH17bo3kc+m6fYrYxrS5xDfno/hhssbkOr9f+vheFgPhkbL2w8J486xqVC84HbUWCNfmtfTIM/tqp0qdsNlal+RT+B/zVi2h3A/9o/1Nz3LUU/C8x/wwTKusw+Tw/5wODXlTpl72X5X7mVNk9bPb4w8yFL1xKM47jCEt+fmyHv/8bnJJ0d3f7bpXXpWdHA6BxGdGZf6ZrjTOXF6TfHxmOFahUDsV3inhIQ36DOZeMUMbyPf8dScjmzLCxFt9JGM+lR9+n4+piE94s0XSLtJ9B++suviY6t1L1z44EibxvE5xYKYwCSLz8ug65YtdzCvrk0rYRvUuTRLbi9ZR4Lmx4T8+Wg3EKfmdCgTFt9Gcpb9LJOAtgjnGubg5bmdkwvEaTKzRxn3zesMXVRm3+X6eZ/cz+t8m21RxxhfZTrE+dB/a56re+pXr5krFkPLlSiR6gSQ5lGeBa8nzKu9xjr9kiDSe5m1uzfAk59D6QxCIuXXwrfj2exZOlFCYkCCHENweSKcD3OX4duBYNkjyq7XwE960lGSlvvBF8pWF/gqLuQhveVPOV7zic1BZTfhWDsmOFxxx9u26+va8qg9uFpZ5k40b3AFtpGNySxRqunuLTfeD8ZwKp8ewN4OJbsPQTvh8JaTQMi4BF4sQ511XIceZRojuEbRJ+vbhMT6sQ5+uIQ+JbSvZfyeR+iHPmhHZc2mJocP0/OnuPO2pxL+5o+NF63btTHm3MgJTD3sYH8u5hHpA1mx52cH2NdRFm5TI/DTcw51/Pj18O3ugLuWTJSQGEa2MEGG2YEvWkBPOMoUi4ySnUV+Ihn69PmM+nFMQ3rynYaLN2BsGCpzooLNes14ICGxGE+nfPhO+Tri0rkbvaI+TfMWyiPbJWS9GLkEpTanKE67STE5PzK/jUft05zidQC9Gkh389RGXLW4OTbYokx33IEv6LlMWwklaLXxuI/VO5+vPZT3tLNVOoRx49AmB8UcvjKBvA/m66C17Yw3WmD+RvgJEoVyiGh/ZotIH8k8PrSvf2HIfq0e+YlkZkv+4Mb79W3YPUg5YUJyRiy9F8x3PjGG0WI5IhSLEixichz5MRkuLiuJ7L0+I18c0xg9jUUk9ZuF2rw+268bFada09rBN5X/2fy4BMPGwWP4oTHtNwBmg8+Q/Rb1/Crwkvhv4RbwRGkJxunZXoPjdYFp3L72eur+3qSwyfsr/+4B/q8rzR/vmxUvxd6dn0ZnHPE0PMfVYut9unmmYSIZ7/nla/gwmaj6qcVj8ig2lkU2FVx2KJ4+IUlZoEsGCuBqRAC5ytcf1jU9Fv7K0uEs8hPJsr1/VFb6jPpxIjRG70nV/yg7egzPd+PtxbW+Q9vu8tYcn2KLObMVfi2xftckCbaTcGy+zTquR9c662v1t+Cp19gx865Hf0Y3inbQFzdw9IT7bJ9jw94c7YM0BqqFX94XYYDS/PXpz3bJn7fjWLgO31xG+kjGe/4c55CN6edRjllPfHg++61PmJDk7PIw+DcKAiIUhDN9tKH6hQz8FNk8L9qQz8BXJyZclGe/HT3Hl/3VNpoheUqWQgwiXNYr631sv4P5Da3jHHqweirf+RVC+9piKr/y070ub03kbe3H4gqetOXQHtdaghP5KRcfmIEP6nZ51fzxvlnzEI3LMq5HPiJ9IOvs6d01LJ66p6ECP73nkJ+v9WeZb0fz2a9sooSESTsEll9Aa9MrHsvMi8eK5i8nO+VDEu/H7CKZiYd8+n4upo5fr/fz39dvSPDefuxmuCa7a+9O1zSHR45lzetnO864tSmfli5xPeEJULsb+z0O+2XlrwVjD06HNG7GIh/tCJfXzB8fxnUP+SaNbTkWrkc+Ir2XWXvmc0i/IYkWp5BNlJAUPgcaeeHbCxlkz93sXWf0jrJ8xWK2nlCQlVmt+Rr22R9THov9ljHbyBZfG3fXXztf9tPWsfGaryHbi/XHae+Ab4mx+LGce0piOF88N+dD/VtOjcXi1jv3sePszc6uA/ssNa9Lx7JXdO0n2i/Pv5Pgayjd9eUbwDSv4p9ecD7CG712xOGa+aMkY8if6SnW+n7rzxAXdwrMZHytlHv68JmB2Y3x3cZTnhPnm2W+07Y5chvDPEh5h4Rkp8janQTuKs5T5IsHdVOhXiuBUKTv09XsI/kUsjFzGTPOJX4usR0z9qPaMI/uiWk0diSbep14/vA957hz+kb8vsQc5yrt0J7y7Jza31zzvslvcU74J+u+fdNIm+yshGTCZes+xWmTDxvGbxjcHtLDlu24znrIrcQH+qHS7NmG26ijZDur1+Ssg00yprEg97aQc8l9UUeJmNgeMvbNMi/3vrztFtt4hI+58hyBFebl25BfUkY+hmSs5/ol43pb88Mf0/MH9iyL6q2dv7O2u+z2Lh/+W/vyehqSQ39rGc1hWpnh0M77dt9T+7s9ork84JxIT4spo/PtucZfs18lJAutjm0w9kE5dtiaPTasIZ/c3/fhNuKBjPtBxyXruQ4byKxEHbqoHGMT9Ytk3hfaVuJr/XwdslpZ8wN7+Fu6xPj5rw3nR8+IwXTR603WWz36wKavtH59evgesvF6xAO5b8Mv5Ci9PeT3KhEn4vKlxeVlY9pD/e41X40rBG5BQAnJLeip78MiYIcGf8YcIrfY2Fh+TB5/jjrGQ9kXA9twLH1y00HPdfSv6Wpy9FtriTn60uL1Mm6zHnNjfa0OW5VCYCsIKCHZykopzs0hYAeFfbisHR598s1NXAGPQgBrHhmDM9DBdmyJfiqFwJYQUEKypdVSrLtBQAfLbpZy0YkgURniz6JBaTAhMBECSkgmAlJuhMA1COBgsb582FzjS30eBwHmCjiE8nFQ0Ez3hsBXQvLx8dHUvv/6938afYWBOCAOiAPr5IAlI1qbda7NPdZlq4nKV0LSNwEDVB8hIASEgBAQAkJACMyFgBKSuZCVXyEgBISAEBACQmA0AjcnJHiXOXpEGQoBISAEhIAQEAJCwCGghMQBoqYQEAJCQAgIASGwPAKH//38p7Fv36fvNyR6QtKHnHRCQAgIASEgBITAGASUkIxBSTZCQAgIASEgBITArAgoIZkVXjkXAkJACAgBISAExiDwfynOrUv0FXTuAAAAAElFTkSuQmCC" class="fr-fic fr-dib"><br>
</div>


<div>
Looks like the view GUI is "confused" (I've literally never used the GUI to create a view, but it looks like it may be the GUI to me). &nbsp;<br><br>SQL Server does not allow a column name there. &nbsp;Look at the "estimated query plan" instead -- if THAT shows you a table_name.YEAR, then please let me know, because that would be a serious bug in SQL Server.
</div>


<div>
(Probably not what you want to hear, but...)<br><br>As an aside, any chance we can convince you to ditch the GUI and type your view T-SQL in an SSMS &gt; New Query window?<br><br>Whenever I hear the words 'query designer' or 'gui', and those Erwin data modeling folks love me for this comment, I think of amateur programmers that run the risk of creating something less that what T-SQL fully supports because of shortcomings in whatever they are using. &nbsp;And the resulting code that is generated is not cosmetically easy to read, and often without the ability to include code comments, which makes supporting it more difficult.&nbsp;
</div>


<div>
Once you've set up the view with the GUI, you can script out the view to start working with the actual T-SQL query that makes up the view. &nbsp;There are many things the GUI does not handle, so it's good for your own sake to start being able to use "raw" query code rather than just the GUI.
</div>


<div>
seems to work ok for me :<br>SQL Management Studio v &nbsp; 18<br>SQL Server 2019<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w20/1561082/ee.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w20/1561082/ee.png" class="fr-fic fr-dib"></a>
</div>


ee.png

<div>
Case 1. If you want to change the field [year]:<br>DATEADD(MyTableName.year,-1,GETDATE()) should be:<br><br>UPDATE MyTableName SET [year] = &nbsp;DATEADD(year,-1,GETDATE()) WHERE pk = ...<br>In this expression [year] is the column of the table MyTableName. WHERE defines what row(s) should be changed.<br><br>DATEADD(year,-1,GETDATE()) = Date Add YEAR (date part), -1 (how many - 1 year), GETDATE() - to what date.<br><br>Case 2. If you have [year] and [month] and you want operate with date then:<br>SELECT ... FROM ... WHERE <strong>DateFromParts</strong>([year],[month],1) &gt; DateAdd(year,-1,GetDate())<br>&nbsp;<br>Case 3. Reserved words. To use a field with the name - reserved word, - put the name in the square brackets: [year], [month].
</div>


<div>
<a href="https://www.experts-exchange.com/questions/29215834/SQL-Reserved-word-issue.html?anchorAnswerId=43288710#a43288710" rel="ugc">https://www.experts-exchange.com/questions/29215834/SQL-Reserved-word-issue.html#a43288710</a>&nbsp;<br>"1. first is the Datepart parameter which can be provided in full words or in abbreviations. Hence year or yy or yyyy means the same and similarly for month, day and other datepart parameters. More details on other datepart parameters can be referred in MSDN article here.."<br><br>I don't need to be given basic syntax. &nbsp;<br><br>What I said, and what I stick to, is that this is valid:<br>SELECT DATEADD(YEAR, 1, year) FROM ( VALUES('20210101') ) AS years(year)<br>and this:<br>SELECT DATEADD(years.YEAR, 1, year) FROM ( VALUES('20210101') ) AS years(year) --INVALID<br>&nbsp;is NOT, and SQL will NEVER allow it. &nbsp;SQL will NEVER generate a SQL plan with that in it, because the first param CANNOT be a variable or column name.<br><br>"DATEADD(yy, -1,GETDATE()) instead of DATEADD(year, -1,GETDATE())<br>Meaningless. &nbsp;Again, SQL will NEVER "confuse" '(year' as a column name because a column name is <strong>NEVER&nbsp;</strong>allowed there.
</div>


<div>
Scott, Sorry for the confusions as all the statements are addressed towards author and not addressed towards you..<br>I've explained to the comments given by author and I was asking him to try those options since he mentioned that the year datepart was strangely getting replaced with Tablename.year field.<br><br>&gt;&gt; I don't need to be given basic syntax. <br><br>I agree and I would never give basic syntax to an experienced expert like you..<br><br>&gt;&gt; Meaningless. &nbsp;Again, SQL will NEVER "confuse" '(year' as a column name because a column name is <strong>NEVER&nbsp;</strong>allowed there. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br>Yes, that's correct and I agree to that..<br>but somehow the author was facing this issues in his environment and hence asked him to check whether the SQL Server SP is on the latest level or not and upgrade as required.
</div>


<div>
Thanks all, going to upgrade SQL next year!
</div>


<div>
<div class="content wysiwyg-content fr-view">
I want to use this formula for a date range:&nbsp;<pre><code class="code-1 nolinks" id="code-10-29215834-1"><span>&gt; DATEADD(year,-1,GETDATE())</span>
</code></pre>There is a field in the table so SQL converts the formula to:<br><pre><code class="code-1 nolinks" id="code-10-29215834-2"><span>&gt; DATEADD(MyTableName.year,-1,GETDATE())</span>
</code></pre>Anyone know how to get round this?
</div>
</div>



I want to use this formula for a date range: 
> DATEADD(year,-1,GETDATE())
There is a field in the table so SQL converts the formula to:
> DATEADD(MyTableName.year,-1,GETDATE())
Anyone know how to get round this?

SQL Reserved word issue

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.