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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Options
NAV 2016 – Export Analysis View To Excel – Date Formatting Issue
DIRHUB
Member Posts: 2
Having following issue and hope someone will help resolving it or point me out the right direction.
From the Page "Analysis by Dimensions Matrix" (9249) while Using the Page Action “Export to Excel” that calls CodeUnit 424 – "Export Analysis View " I am able to output an excel sheet with all relevant pre-filtered data.
The problem I see is the date format that is not the same on all lines which makes it extremely difficult to easily select the date range that I require. It looks like some dates are text format and some are a date format. I cannot sort them to get them in order either as it just won’t sort without additional cell formatting and fiddling with the values. Just to say, even when I select just the date range of the 01/11/17 to 31/01/18 the date format is not the same for all dates, some in an English format (dd/mm/yy) coming through as text and some in an American format (mm/dd/yy) formatted as date… (see below the attached screenshot)
My local computer regional settings are English UK.
How can I keep the date formatting consistent across the list with correct Date formatting?
Also tried some additional formatting to format the output on the Line2 level by adding desired formatting code but despite of the fact that some of the values are parsed correctly formatted, Excel is interpreting them as text.
Searched various forums with plenty of conflicting advices found but none of them helped resolving this.
Would appreciate your advice on this.
Thank you.
Kind regards,
Marcus
From the Page "Analysis by Dimensions Matrix" (9249) while Using the Page Action “Export to Excel” that calls CodeUnit 424 – "Export Analysis View " I am able to output an excel sheet with all relevant pre-filtered data.
The problem I see is the date format that is not the same on all lines which makes it extremely difficult to easily select the date range that I require. It looks like some dates are text format and some are a date format. I cannot sort them to get them in order either as it just won’t sort without additional cell formatting and fiddling with the values. Just to say, even when I select just the date range of the 01/11/17 to 31/01/18 the date format is not the same for all dates, some in an English format (dd/mm/yy) coming through as text and some in an American format (mm/dd/yy) formatted as date… (see below the attached screenshot)
My local computer regional settings are English UK.
How can I keep the date formatting consistent across the list with correct Date formatting?
Also tried some additional formatting to format the output on the Line2 level by adding desired formatting code but despite of the fact that some of the values are parsed correctly formatted, Excel is interpreting them as text.
Searched various forums with plenty of conflicting advices found but none of them helped resolving this.
Would appreciate your advice on this.
Thank you.
Kind regards,
Marcus
0
Comments