January 29, 2013 at 2:02 am
Hi All
I am trying to use the DateValue function on a table in SQL Server Express 2012 but it says that it is 'not a recognized built-in function name'. Has it been removed from the express version or have I done something wrong in the installation?
Thanks
January 29, 2013 at 3:14 am
DateValue is not SQL Server T-SQL function. It is a DAX one. You need SSAS in order to use it.
January 29, 2013 at 4:30 am
Thanks SSCrazy, as express doesn't support SSAS I will have to do this a different way.
January 29, 2013 at 4:51 am
You are welcome Forum Newbie 😉
Such a strange nick name you have... :hehe:
January 29, 2013 at 4:54 am
Look at cast or convert using a date style http://msdn.microsoft.com/en-us/library/ms187928.aspx, style 100 or 109 may be the ones to go for.
January 29, 2013 at 5:18 am
Eugene
Message to self, 'Must read whats on screen before replying' 😀
Anthony.
Thanks for the link will have a play.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply