Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Remove time stamp from column date field in report extension

(0) ShareShare
ReportReport
Posted on by 479

I am only trying to display the Month, Day, and Year in my date field on my report.

This is what is showing up on the report after adding the field on Word (via XML Mapping):

Screen-Shot-2022_2D00_05_2D00_17-at-12.03.51-PM.png

How do I remove the time "12:00:00 AM"?
Also, is there a way of reformatting the date into words like "May 17, 2022" instead of just digits like in the photo?

I must note: the column field is a custom field date I made in one of my extensions.

Thanks,

  • jdrco Profile Picture
    479 on at
    RE: Remove time stamp from column date field in report extension

    Thank you!

  • Suggested answer
    Alok.kulshreshtha Profile Picture
    934 on at
    RE: Remove time stamp from column date field in report extension

    hi, 

    Go to RDL Report Layout and right click on the text box for date. in the text box property, click on number. in right hand side you will get a category and click on date. in Type section you will get multiple option to choose.

    pastedimage1652812467933v1.png 

    Regards,

    Alok Kulshreshtha

    Please Verify my answer if you find my post helpful.

  • Verified answer
    Binesh Profile Picture
    7,885 on at
    RE: Remove time stamp from column date field in report extension

    Hi, Format the data in REPORT.AL file and in word layout use RichText to show the data.

    pastedimage1652812057077v2.png

    pastedimage1652812076373v3.png

    docs.microsoft.com/.../format-property

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,283 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,025 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans