Post reply

DateValue Function missing in SQL Server 2012 Express

  • January 29, 2013 at 2:02 am

    #273519

    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

    #1581973

    DateValue is not SQL Server T-SQL function. It is a DAX one. You need SSAS in order to use it.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • January 29, 2013 at 4:30 am

    #1582012

    Thanks SSCrazy, as express doesn't support SSAS I will have to do this a different way.

  • January 29, 2013 at 4:51 am

    #1582029

    You are welcome Forum Newbie 😉

    Such a strange nick name you have... :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • January 29, 2013 at 4:54 am

    #1582034

    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

    #1582048

    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