How to change date format in pro form invoice report

(0) Share

Report

Posted on by Revathi.T

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") { }

}

Categories:

Business Central

All responses (3)

Answers (1)

Revathi.T 76 on at

Like (0)

Report

RE: How to change date format in pro form invoice report

Thank You Mohana Yadav. It works now.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

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.
Verified answer

Mohana Yadav 59,127 Super User 2024 Season 2 on at

Like (0)

Report

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)) { }