Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Semi-Quarter and Semester on a Matrix form.
kirkostas
Member Posts: 127
I want to add semi-quarter and semester on two matrix forms. The forms are the 7139 and the 7117. I am thinking to create a second Date table with Period Type (Semi-Quarter, Semester), Period Start, Period End, Period No. and Period Name fields and enter periods for years from 2000 to 2100.
Is there any other easier solution?
Is there any way to do this with the system's DATE table?
Is there any other easier solution?
Is there any way to do this with the system's DATE table?
kirkostas™
0
Comments
I wouldn't go for creating a new own date table. And modify the system date table isn't possible.
I would try to expand PeriodType by Semester and modify the function FindPeriod.