Tuesday 5 October 2021

Error 'The value 01/07/21 cant be evaluated into type date'




 I happened to encounter the above error. The rest of the users can run the same report without any issue. The problem is isolated to just this single user.

First i noticed the date format on the users PC is set to dd/mm/yy.

  • To resolve the issue, change the date format to mm/dd/yy on the user's PC
  •  Run the report, clear any date filters that are set on the report request page
  • close the report
  • Change the date format settings back to dd/mm/yy on the PC
  • Close NAV and restart NAV
  • The issue should be resolved


No comments:

Post a Comment