How to display date as Week number?

Tsuyoshi_Inoue1
Tsuyoshi_Inoue1
in Modeling

Hi experts,

 

Could someone give me an advise for showing date as active week code?

In my model, standard week is converted to active week and requested shipping date.

clipboard_image_0.png

Then, my client argues that we should export Demand forecast data in active week style (e.g. 202023 ).

This is what is exported.

無題.png

 

Is there any solution for this? How to use CODE function for list item?

 

Regards,

Inoue

Tagged:

Best Answer

  • kavinkumar
    kavinkumar
    Answer ✓

    I hope you are trying to do the export and you are expecting the code to be displayed in your export file. Hence this option will be available during your export. Else if you want the code in your module, then create a line item (Text formatted) and put a formula 'CODE(List formatted line item)'.

    Hope this clarifies!!

     

    Kavin.

Answers

  • Tsuyoshi_Inoue1
    Tsuyoshi_Inoue1

    Additional:

     

    In the module subset 010ActiveWeek is used as an axis. What we want to show is Code.

     

    clipboard_image_0.png

  • kavinkumar
    kavinkumar

    HI @Tsuyoshi_Inoue1,

    If you want to export the code instead the name of a list that is used in a line item, please make use of the 'line items of Data-Type List' tab in the export action. It defaults to Name, you can modify that to code.

    How to display date as Week number..PNG

     I hope this helps!

    Regards,
    Kavin.

  • Tsuyoshi_Inoue1
    Tsuyoshi_Inoue1

    Hi Kavin,

     

    Thanks for your advice.

    I cant find the "Line Items of Data-Type "List"", where can I find them?

     

    Regards,

    Inoue

  • Tsuyoshi_Inoue1
    Tsuyoshi_Inoue1

    Hi Kavin,

     

    This is solved.

    I appreciate for your kind suppport!

     

    Regards,

    Inoue

Categories