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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Changing Date format to be displayed in report

(0) ShareShare
ReportReport
Posted on by 700

Hi All,

In a report, I have a field for displaying Date of Birth of employees, in which the format of date being displayed is DDMMYY.

But, instead of this format, I have to display the date as '31 January'.

I tried 

"column(Birth_Date; format("Birth Date", 0'<Month Text>')) { }"
 
on report but it is showing only month names.
How this could be achieved ?
Please suggest !
I have the same question (0)
  • Suggested answer
    Raju Gudipalli Profile Picture
    185 on at

    Set format property for the textbox to dd MMMM.

  • Verified answer
    Community Member Profile Picture
    on at

    change format to

    format("Birth Date", 0, '<Day,2> <Month Text>'))

  • Dynamics 365 Business Central Profile Picture
    700 on at

    Thank You, it worked !

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,084 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans