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
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
2.
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
Hi Rohit,
You can use DateTimeUtil::toFormattedStr method to convert it to string.
Thanks,
Girish S.
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:
For the 2nd question you can use any2str() and then substr() to trim last values. Not sure about 1st one.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156