Change first day of week

Solmyr
Member Posts: 51
Hi all
Is it possible to change the Date virtual table first day of week to "sunday"?
Thanks in advanve!
Is it possible to change the Date virtual table first day of week to "sunday"?
Thanks in advanve!
Oleg Dovgalenko
0
Comments
-
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.0 -
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.Oleg Dovgalenko0 -
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=50 -
Thanks Mark, very knowledgeable stuff. :thumbsup:0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions