News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to retrieve DateTi...

Finance | Project Operations, Human Resources, ...

Unanswered

How to retrieve DateTime from table as is.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello all,

Here again to ask a question regarding extracting the DateTime without it auto-converting.

As you can see from the image, I want to retrieve the 12:27:08 time from the table instead of getting the 4:27:08 value.

Does anyone know a way?

All responses Img

All responses (4)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to retrieve DateTime from table as is.

Hello sir, yes its from the correct field, I just needed to refresh the table because my job updates the Start time.
WillWU 22,352 on at

Like (0)

Report

RE: How to retrieve DateTime from table as is.

Hi Charos,

Please make sure you have selected the correct field.

The time you got from your code is 4:32:08 and the minute is not correct, this may not be caused by the code.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to retrieve DateTime from table as is.

Will try it Mr. Wang, thank you for this, will tell you if it works. Thank you good sir.
Blue Wang on at

Like (0)

Report

RE: How to retrieve DateTime from table as is.

Hi Charos,

I tried this. it's correct.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans