Transdate issue

(0) Share

Report

Posted on by rohit1900

439

Hi All,

1. I have created one table with a date field with type Transdate -EDT , but when I export the data from the entity it show as below

6406.Capture.PNG

it is showing s YYYY-MM-DD HH:MM:SS

is there any specific date type EDT in D365 which exports the date only in proper Date format rather than above Date format like this YYYY-MM-DD HH:MM:SS

How to convert string YYYY-MM-DD HH:MM:SS to date

what I mean is that if some how I get the datetime in above format in string format, how can I get the date from this,

I checked few str2date format it is not helping me,

Kindly suggest some thing regarding this

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Transdate issue

Hi Rohit,

You can use DateTimeUtil::toFormattedStr method to convert it to string.

Thanks,

Girish S.

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (0)

Report

RE: Transdate issue

Hi rohit1900,

You can go to the visual studio check the property of the date field with type Transdate -EDT, and change the format based on your requirement:

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

RE: Transdate issue

For the 2nd question you can use any2str() and then substr() to trim last values. Not sure about 1st one.

Was this reply helpful? Yes No