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)

Suggested answer

Andy Sather on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Lars Lohndorf-Larsen on at

Like (1)

Report

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,468

#2

YUN ZHU 923 Super User 2025 Season 2

#3

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans