Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Date format in SSRS
Microsoft Dynamics CRM (Archived)

Date format in SSRS

(0) ShareShare
ReportReport
Posted on by Panky 155

Hi All

In SSRS, I am fetching the created on attribute of an entity through fetchxml. The Date is showing as "dd-mm-yyyy hh:mm:ssss".

I want the date portion only and also, the date should appear as dd-Month-yyyy i.e 25-September-2017

*This post is locked for comments

  • Verified answer
    Panky Profile Picture
    Panky 155 on at
    RE: Date format in SSRS

    Found the resolution. Can format the expression of date according to Date and Time and include Month in it.

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Date format in SSRS

    Hi,

      you might want to use a formula there:

    =FORMAT(Fields!ModifiedDate.Value,"dd-MMMM-yyyy")

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans