Unable to import Date from XML port to table.

Mohsin_abbas
Member Posts: 1
Hi, I'm trying to fetch invoices through XMLPort and saving them in tables. All is going well except for the date where it says that '11-10-2016T 00:00:00' can not be saved in Date type field. In order to manipulate the date and make it compatible with 'Date' data type, I changed its datasource from 'field' to 'text' and then changed it to correct format using code in the trigger InvoiceDate -Import::OnAfterAssignVariable(). Now the error is removed but issue is, it does not insert the date in table field(field is left blank). What could be the possible reason?
0
Answers
-
As a guess, you are probably not assigning the value to the date field. You should really post your code if you want others to help you identify what is wrong with it.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