14,503 questions
Try this filter:
= { fn CURDATE() }
= CAST(GETDATE() AS date) filter in views .... BUG in management studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 46%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Evan Camilleri
1
Reputation point
If i enter this
= CAST(GETDATE() AS date)
as a filter on a date in the view designer, I get
Data type error in expression
BUT if i type it in the SQL script (of the same designer) it works OK
SQL Server | Other
{count} votes
-
Olaf Helper 47,516 Reputation points2021-08-24T09:56:50.58+00:00 Can confirm, I get the error, too.
One of many reasons why I never use the designers in SSMS.
Sign in to comment
2 answers
Sort by: Most helpful
-
Viorel 122.6K Reputation points2021-08-24T11:14:33.767+00:00 -
Evan Camilleri 1 Reputation point
2021-08-24T11:51:20.283+00:00 If I do a function I guess it would work BUT why it does not allow me I guess it's a bug which has been there for ages
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2021-08-24T21:50:56.183+00:00 Bug? Rather a limitation. As Olaf says, stay away from the View Designer. It's crippled, and this is only one token of that.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-08-25T07:00:49.473+00:00 Hi EvanCamilleri-5895,
Welcome to Microsoft Q&A.
This issue happens to me. I’m not sure if it is a known issue or by design.
I recommend you submit a feedback to this link: https://github.com/MicrosoftDocs/sql-docs/issues
Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.