I have problem when trying to send SQL data (type datetime) to NAV (field also datetime). There is error telling me that date is incorrect.
*This post is locked for comments
What is the date value?
Could you post the exact error message?
Error message is teling me only Date is not correct.
The problem is that writting data directly to NAV tables at the SQL level is not supported, but is there alternative. Don't know how to solve this problem.
You can use XMLPORT to import data by using .CSV or .txt file
Try to convert your date to have some format as your dynamics nav format ---with convert function something like this :
convert(datetime, '10/23/2016', 101)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Alexander Ermakov 2
SC666 1
