web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Date is not valid

Small and medium business | Business Central, N...

Suggested Answer

Date is not valid

(0) Share

Report

Report

Posted on by Narayan Krishna Shr...

5

OnAfterGetRecord()
IF "Solved Date" = 0D THEN
Aging := WORKDATE - "Reqeusted Date"
ELSE
Aging := "Solved Date" - "Reqeusted Date";

Aging is integer data type.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Andy Sather Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Would you be able to describe the issue you are running into?

Was this reply helpful? Yes No
Suggested answer

Lars Lohndorf-Larsen Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Narayan,

You are right that Date - AnotherDate should return an Integer. But only if the date is defined. If one of the dates is undefined, then you get the error. So you need to test more for 0D, for example

IF "Requested Date" <> 0D THEN

Aging := WORKDATE - "Requested Date"

ELSE

Aging := 0 // (or any ohter default value)

So in this code you test correctly on "Solved date", but you also need to test that "Requested Date" <> 0D before you can use it in a calculateion,

hope that helps

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,138 Super User 2026 Season 1

#2

YUN ZHU 1,279 Super User 2026 Season 1

#3

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans