web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Format Posting Date to...

Microsoft Dynamics NAV (Archived)

Format Posting Date to display date only

(0) Share

Report

Report

Posted on by Community Member

Hi

My apologies if I put this in the wrong forum...

I am using nav 2015 and am creating a Word report layout using office 2013.

In the report design, I have added a field "Posting Date"
When I add this field to my Word report, I get the date and time displayed.
However, I just want the date to display.

Could someone point me to a post that explains how I can do this please.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mohana Yadav 60,979 Super User 2025 Season 2 on at

Like (0)

Report

RE: Format Posting Date to display date only

Please add FORMAT("Posting Date") in Report design and it should solve automatically in word layout.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: Format Posting Date to display date only

In your design change the source expression to FORMAT("Posting Date",0,'<Closing><Month,2>/<Day,2>/<Year>') and you can define different formats, check the link for different formats you can use

msdn.microsoft.com/.../dd301059(v=nav.80).aspx

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Alexander Ermakov 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans