Share via

D365 BC - AL Table Date Fields - Manually Entered date being translated to Incorrect Date

Rajbir Kaur Cheema 1 Reputation point
2026-03-27T14:12:48.8666667+00:00

This is about Business Central AL Table's date field: I am experiencing an issue with a date field on a page. When a date is entered manually (e.g., 12312024), it is automatically converted to an incorrect format (12/31/02024), resulting in an invalid value.

Additionally, I have validation logic on the OnValidate trigger that compares this date with other dates. Due to the incorrect conversion, the validation consistently fails and raises an error. As a result, users are forced to select the date manually from the calendar control instead of entering it directly.

Developer technologies | Visual Studio | Extensions
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.