web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

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

How to change date format in pro form invoice report

(0) ShareShare
ReportReport
Posted on by 86

In my pro forma Invoice Report, Due Date field showing Date in the format like 3/21/2023 12:00:00. But I required to display the my due date field as March 21, 2023. How to do this?

In my VS Code, I added "Due Date" field from the Header as well as from the dataitem (Sales Header), and used the dataset in the word layout of pro forma invoice and updated the layout and still i cannot able to get my required format. where to change the format to get required format as March 21, 2023.

           
reportextension 50149 proformainvoicereportext extends "Standard Sales - Pro Forma Inv"
{
    WordLayout = './StandardSalesProFormaInv.docx';

    dataset
    {
        add(Header)
        {           
            column("DueDate"; "Due Date"{ }           
        }
        addfirst(Header)
        {
            dataitem("Sales Header"; "Sales Header")
            {
                column(Due_Date_; "Due Date") { }               
            }
}

    }
}
pastedimage1678430261764v1.png

I have the same question (0)
  • Verified answer
    Mohana Yadav Profile Picture
    61,248 Super User 2026 Season 1 on at

    Change it as below and try

    column(Due_Date_; Format("Due Date", 0, 4)) { }

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    you can directly open the RDLC report designer and change the Textbox property as per below.

    pastedimage1678432234864v1.png

  • Revathi.T Profile Picture
    86 on at

    Thank You Mohana Yadav. It works now.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 521 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 306 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans