DateTime --> datatype

(0) Share

Report

Posted on by Community Member

I am trying to import a txt file and the data is 2005-02-09 13:30:36.493000000 and iam using datatype as datetime and iam getting error ---> "The date is not valid".

what can i do in this case is this region issue or anything else!!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Roger Larsson 25 on at

Like (0)

Report

Import as text, the evaluate into DateTime using XML-format (9).

Was this reply helpful? Yes No
Suggested answer

pankaj.k 994 on at

Like (0)

Report

Hi

you need to Remove Red marked value because its take only 3diget for millisecond 2005-02-09 13:30:36.493000000

Please check URL : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/datetime/datetime-data-type

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

You can try below code

var

DTTextValue: Text;

newTime: Time;

newDateYear: Integer;

newDatemonth: Integer;

newDateDay: Integer;

NewDate: Date;

begin

DTTextValue := '2005-02-09 13:30:36.493000000';

EVALUATE(newTime, COPYSTR(DTTextValue, 12, 11));

EVALUATE(newDateYear, COPYSTR(DTTextValue, 1, 4));

EVALUATE(newDatemonth, COPYSTR(DTTextValue, 6, 2));

EVALUATE(newDateDay, COPYSTR(DTTextValue, 9, 2));

NewDate := DMY2DATE(newDateDay, newDatemonth, newDateYear);

MESSAGE('%1..%2', NewDate, newTime);

end;

Was this reply helpful? Yes No