Notifications
Announcements
No record found.
Hello Microsoft Community I have a small problem with Navision Classic, an error during the validation of the course of the table (see screen below). Several questions : Parameter 2 corresponds to what? The value DMY2DATE corresponds to an entry type date MM / DD / YY, that I know but when I look at the column where the dates returned there is for me no error. If someone has already had this error message I appeal to your support to help me solve this situation. Thank you in advance. Regards, CONESA BRANDON
*This post is locked for comments
Hi,
Parameter 2 in DMY2Date is Month. Please check here: https://docs.microsoft.com/en-us/dynamics-nav/dmy2date-function--date-.
Hope that helps. Somehow you month value is 0 during validation and that causes the error.
Best regards
Andreas Günther
Escalation Engineer
Microsoft Dynamics NAV / Microsoft Dynamics Business Central
Thank you for your help, I would look if it works I'll let you know
It is the month, for example, DMY2DATE(30,12,2019) gives December 30, 2019
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.