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

All responses (3)

Answers (1)

Suggested answer

Nitin Verma 21,384 Moderator on at

Like (0)

Report

RE: DateTime --> datatype

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;
Suggested answer

pankaj.k 970 on at

Like (0)

Report

RE: DateTime --> datatype

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
Verified answer

Roger Larsson 25 on at

Like (0)

Report

RE: DateTime --> datatype

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