Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Date format as MM/YYYY
Roelof
Member Posts: 377
Older NAV versions were able to define customized date formats in CU-1. Currently in newer versions like NAV2018 and 365 BC, after Microsoft has redefined CU's, these formats suppose to be handled in CU-45. By using table field properties 'AutoFormatType' and 'AutoFormatExpr' and related code in CU-45 (function AutoFormatTranslate) as:
Case AutoFormatType of
3: Exit('<Month,2>/<Year4>'))
END
But it's not working the same. As a matter of fact it's not doing anything.
Are there any other ways to get the same result? This should be for displayed fields and fields which can be modified.
Case AutoFormatType of
3: Exit('<Month,2>/<Year4>'))
END
But it's not working the same. As a matter of fact it's not doing anything.
Are there any other ways to get the same result? This should be for displayed fields and fields which can be modified.
Roelof de Jonghttp://www.wye.com
0
Answers
It will not be triggered when you use a Date field. I added your code (3: Exit('<Month,2>/<Year4>'))) to cu1 in a classic NAV 2009 database, and it isn't even working there. How old were these nav versions? Or am I missing something here..