Skip to main content

Notifications

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

How to change date format in pro form invoice report

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

Categories:
  • 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,127 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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans