Change first day of week

Solmyr

Hi all
Is it possible to change the Date virtual table first day of week to "sunday"?
Thanks in advanve!

Marije_Brummel

No, you cannot change the virtual date table, however you can create your own.

Recently I had the same challenge where all the customers' analysis had to be done from saturday to friday, meaning week starts at saturday.

To achieve this I created my own virtual date table and used it in the Matrix management codeunits, this worked like a charm.

You need to create some initialise functions since if you create your own table it is not populated by default.

Solmyr

Mark Brummel wrote:

No, you cannot change the virtual date table, however you can create your own.

Recently I had the same challenge where all the customers' analysis had to be done from saturday to friday, meaning week starts at saturday.

To achieve this I created my own virtual date table and used it in the Matrix management codeunits, this worked like a charm.

You need to create some initialise functions since if you create your own table it is not populated by default.

Thanks for the answer! Could you please explain it in more details? You created physical table in the database? How is it possible to create custom virtual tables?

Marije_Brummel

Yes, you need to create a table in the object designer, but it just behaves as a class and will never contain any data in SQL. If for a customer it does not need to exist in the license.

This video shows how to work with temporary datasets in Dynamics NAV

https://www.youtube.com/watch?v=QHn5oEO ... _w&index=5

vivek4121

Thanks Mark, very knowledgeable stuff. :thumbsup: