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 :
Microsoft Dynamics NAV (Archived)

How to display Date in dd/mm/yyyy

(0) ShareShare
ReportReport
Posted on by 3,099

Hi

   How to display Date in dd/mm/yyyy in reports

Thanks

*This post is locked for comments

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

    Did you try

    Format(date,0,'<Day,2>/<Month,2>/<Year4>');

  • Suggested answer
    Suresh Kulla Profile Picture
    50,269 Super User 2026 Season 1 on at

    Please check this link for different formatting tips

    dattatreysindol.com/.../formatting-date-and-time-in-sql-server-reporting-services-ssrs-reports

  • Suggested answer
    Vignesh M Profile Picture
    20 on at

    Hi,

    You can also set Custom format (dd/MM/yyyy) in text box property.

  • Community Member Profile Picture
    on at

    thank you so much jsshivalik for for correct answer .

  • 4BzSoftware Profile Picture
    6,073 on at

    Hi Cindrella,

    I think it is Mohana :-)

    Have a nice day to you all!

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans