Week Ending Description Change

Jason Ferguson
Jason Ferguson Customer
Second Anniversary First Comment
edited October 2020 in Platform
Hello 

In the database that I am using I would like to update the Week Ending Time entity so it shows WE 04/10/2020 instead of W.41/20

Whats the best way of doing this?

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
Board Ver: 10.6
------------------------------

Accepted Answer

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes
    edited October 2020 Answer ✓
    Hi @Jason Ferguson,

    i think the easiest way is to create a datareader that replace the description of the entity week.

    image
    For getting the description you can use a sql statement or a textfile (e.g. built from excel).


    image
    Hope it helps




    ------------------------------
    Dietmar Jeschkeit
    Senior BI Consultant
    Braincourt GmbH Gesellschaft für Managementberatung & Informationssysteme
    Germany
    ------------------------------
    -------------------------------------------

Categories