Occasional Contributor

How to display date as Week number?

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

5 REPLIES 5
Occasional Contributor

Re: How to display date as Week number?

Additional:

 

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

 

clipboard_image_0.png

Certified Master Anaplanner

Re: How to display date as Week number?

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.

Occasional Contributor

Re: How to display date as Week number?

Hi Kavin,

 

Thanks for your advice.

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

 

Regards,

Inoue

Certified Master Anaplanner

Re: How to display date as Week number?

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.

Highlighted
Occasional Contributor

Re: How to display date as Week number?

Hi Kavin,

 

This is solved.

I appreciate for your kind suppport!

 

Regards,

Inoue