Forum Discussion

Milozebre's avatar
Milozebre
Helper V
8 years ago
Solved

Week Number is INCORRECT

Good morning Community,    I have a problem with the week numbers. As you see, I see some measure for week 44 and we are in week 33.   SQL :  ,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH    I ...
Need Help
  • Milozebre's avatar
    Milozebre
    8 years ago

    Hello Lydia, 

     

    Sorry for the delay.

    I found the solution.

     

    here is the line in my query for the weeknumber : 

    ,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    I look in internet and i found some solution and the easyer is change something in my query : change ww to ISO_WEEK

    ,datepart(ISO_WEEK,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    Now, its working :) 

     

    Thank you 

Milozebre's avatar
Milozebre
Helper V
8 years ago

Hi Lydia, 

 

thank you for your answers.

Yes, when I run the query, I get several fields then when I use visualization I see that difference. 

I dont know how to give you DDL and DML, sorry.

The database is very big, I can you the export of the query in excel, if you want ?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Milozebre,

Please share me the exported excel file and explain that what fields you use to create the visual.

Regards,
Lydia

  • Milozebre's avatar
    Milozebre
    Helper V
    8 years ago

    Hello Lydia, 

     

    Sorry for the delay.

    I found the solution.

     

    here is the line in my query for the weeknumber : 

    ,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    I look in internet and i found some solution and the easyer is change something in my query : change ww to ISO_WEEK

    ,datepart(ISO_WEEK,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    Now, its working :) 

     

    Thank you