Remove time stamp from column date field in report extension

(0) Share

Report

Posted on by jdrco

481

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,

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Binesh 7,885 on at

Like (2)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Alok.kulshreshtha 934 on at

Like (0)

Report

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.

Regards,

Alok Kulshreshtha

Please Verify my answer if you find my post helpful.

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No