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
- 266 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
'11/29/2011 is not a valid date' On FlowField Drilldown
Jonathan2708
Member Posts: 552
Hi,
I have created a FlowField in a custom table to count the number of Sales Header records for set criteria. One of the criteria is where a date field in my custom table equals the 'Shipment Date' in the Sales Header table. The FlowField counts the records fine, and in Classic I can drilldown on the FlowField to the 'Sales List' form to view the records. However in RTC when I try to drilldown I get the error '11/29/2011 is not a valid date'. Obviously it's trying to apply the filter on the Sales Header table using USA date format, when all my regional settings are for UK.
Can anybody shed any light on this?
Thanks,
Jonathan
I have created a FlowField in a custom table to count the number of Sales Header records for set criteria. One of the criteria is where a date field in my custom table equals the 'Shipment Date' in the Sales Header table. The FlowField counts the records fine, and in Classic I can drilldown on the FlowField to the 'Sales List' form to view the records. However in RTC when I try to drilldown I get the error '11/29/2011 is not a valid date'. Obviously it's trying to apply the filter on the Sales Header table using USA date format, when all my regional settings are for UK.
Can anybody shed any light on this?
Thanks,
Jonathan
0
Comments
http://fichoo.blogspot.com/2011/07/date ... eport.html
Regards,
egnaz