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)

Sort by

Verified answer

Roger Larsson 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,020 on at

Like (0)

Report
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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