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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to format date in ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to format date in ssrs report

(0) ShareShare
ReportReport
Posted on by Huggins Mafigu 507

I want to display date in the format 

1st
, 
2nd
 with the 
st
 or 
nd
 raised etc as shown in the below picture.

DateStRdNd.PNG

What I've managed to do is to display it as 

1st day of 2020
, but I want it displayed as is in the image above.

Anyone with the idea on how I can achieve that in SSRS

I have the same question (0)
  • A.Prasanna Profile Picture
    A.Prasanna 8,223 on at

    check this out  stackoverflow.com/.../formatting-datetime-in-ssrs-expression

  • WillWU Profile Picture
    WillWU 22,361 on at

    Hi Huggins Mafigu,

    I think you can't achieve the requirement that shown in your picture.

  • Suggested answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 507 on at

    This one will have it displayed as 

    1st
    not as 
    1st
    with 
    st
    raised.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    My recommendation is to format the text in x++ in Dynamics and send it as a string to the report.

    Either via display method or using a temp table.

  • Suggested answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 507 on at

    I'm managing to display 

    1st day of November 2020
    (example), but failing to raise the 
    st
     as in the image.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans