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... Error message: The val...

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

Answered

Error message: The value 24.09.2019 00:00:00 cannot be converted to a DateTime.

(0) Share

Report

Report

Posted on by Community Member

Hi, guys,
how can I solve the following problem?

The value 24.09.2019 00:00:00 cannot be converted to a DateTime.

What am I doing wrong here?

Here is my code:

LOCAL TextToDateTime(Value : Text) : DateTime
DateTimeAsVariant := DateTimeValue;
IF NOT TypeHelper.Evaluate(DateTimeAsVariant, Value, '', 'en-us') THEN
ERROR('Der Wert %1 kann nicht in ein DateTime überführt werden', Value);
DateTimeValue := DateTimeAsVariant;
EXIT(DateTimeValue);

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Rehan Satti 636 on at

Like (0)

Report
Copy link

Link copied!

Hi Malue,

You can seprate the string in to data and time and then convert it to datetime variable.

TestDate := 24.09.2019;

TestTime := 00:00:00;

TestDateTime := CREATEDATETIME(TestDate,TestTime);

for more details look at the following link

https://docs.microsoft.com/en-us/dynamics-nav/createdatetime-function--datetime-

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,804 Super User 2026 Season 1

#2

YUN ZHU 1,103 Super User 2026 Season 1

#3

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans