How to fix date error on customer card.

(0) Share

Report

Posted on by Community Member

Cannot open one customer card, all others are functioning properly as far as we can tell.

When I try to open the one customer card I receive the following message: The date is not valid. Page Edit - Customer Card must close.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: How to fix date error on customer card.

Hello,

Well, I suggest you use the debugger to get in which table the date causes the problem then use NAV Development Environment to open it (using Run button) and correct the date manually. you can correct the date using SQL server as well.

--PERHAPS you've changed your date format in Windows/NAV and you stored a date in this format for example dd-mm-yyyy (let's say it's 15-08-2018) then you changed the date format to mm-dd-yyyy which means mm=15 while there is no month 15 !

-------------

Please verify my answer if you find my answer helpful. Doing so you'll show other community members that there was found a solution and you credit my help.

-------------

Best Regards,

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: How to fix date error on customer card.

Activate debugger to check the issue in detail..

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,417 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to fix date error on customer card.

Sis you triggered anything from SQL?

Was this reply helpful? Yes No
Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How to fix date error on customer card.

This is regarding that you system has a different date format then the customer data has the date, in that case, please debug and analysis the problem

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: How to fix date error on customer card.

is there any customization, some date calculation is happening when you try to open the page.

Was this reply helpful? Yes No