Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unhappy Unanswered: datename problems

    Thanks for the reply SG,

    I tried the Set Datefirst prior to running my query and i got exactly the same results (screenshot attached). I even verifird the Datefirst value immediately prior to running my query.

    I suspect you are right however. Are there any other settings i should look at? would it be a service pack issue?

    thanks

    ozz
    Attached Thumbnails Attached Thumbnails screenshot.jpg  

  2. #2
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20

    This mistake is at datename(dw,day(Saledate)).

    This mistake is at datename(dw,day(Saledate)).
    You must change to
    select datename(dw,Saledate) as .....

    See my examples:
    Attached Thumbnails Attached Thumbnails 1.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •