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

Like (0)

Report

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 95,748 Super User 2025 Season 2 on at

Like (0)

Report

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

Thank ZHU, issue resolved

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

Like (0)

Report

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

Was this reply helpful? Yes No