Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

How to change date format in pro form invoice report

(0) ShareShare
ReportReport
Posted on by 76

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

  • Revathi.T Profile Picture
    Revathi.T 76 on at
    RE: How to change date format in pro form invoice report

    Thank You Mohana Yadav. It works now.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: How to change date format in pro form invoice report

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

    pastedimage1678432234864v1.png

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,194 Super User 2024 Season 2 on at
    RE: How to change date format in pro form invoice report

    Change it as below and try

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans