Extracting Date form DateTime data type

(0) Share

Report

Posted on by Muhammad Anas Naeemi

390

Hello everyone,

I have a custom field with datatype 'Date'. I have also used this field in reporting. The issue that I am facing is that when I'm previewing the report, time is also being displayed along with the Date. I just want the date to be printed. Below are the images of the word layout and document that was previewed. Kindly help.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: Extracting Date form DateTime data type

Hi,

Right click on Date field > Text Box Properties and choose what format you want

Was this reply helpful? Yes No
Verified answer

YUN ZHU 93,438 Super User 2025 Season 2 on at

Like (0)

Report

RE: Extracting Date form DateTime data type

Hi, This looks like a Word Layout, as far as I know it is difficult to modify the date format in Word Layout.

So you can convert to the format you need, and output it on the page.

Standard Date Formats:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-property#standard-date-formats

And, Date, Time, DataTime Conversions:

https://yzhums.com/22928/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

RE: Extracting Date form DateTime data type

Thank ZHU, issue resolved

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

RE: Extracting Date form DateTime data type

It is not working as it is word layout and not RDLC layout. But thanks for the answer.

Was this reply helpful? Yes No