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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Can I change the this ...
Microsoft Dynamics CRM (Archived)

Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

(0) ShareShare
ReportReport
Posted on by CRM Develope 894

Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

I have working code in below for custom code.

Dim dt As String = "0112"
Dim dt As New Date(("20" + Microsoft.VisualBasic.Right(_date, 2)), Microsoft.VisualBasic.Left(_date, 2), 1)
here 20 is by default 20 + yy =20yy something.

Output here :- 1/1/2012 working fine.

is it possible in expression in crm reports ?

Thanks

*This post is locked for comments

I have the same question (0)
  • CRM Develope Profile Picture
    CRM Develope 894 on at
    RE: Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

    It's Working Fine...

  • CRM Develope Profile Picture
    CRM Develope 894 on at
    RE: Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

    Thanks for the suggestion Inogic & Somesh Siripuram

  • Verified answer
    Inogic Profile Picture
    Inogic 651 on at
    RE: Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

    Please use below expression in order to achieve above said requirement in CRM report.

    =Format(CDate("20" & Right("0112",2)& "/" &Left("0112",2)&"/" & "01"),"MM/dd/yyyy")

    Note "0112", this is the Field or Parameter value in the above expression as per your requirement.

     

    Thanks!

  • Verified answer
    Somesh2207 Profile Picture
    Somesh2207 1,563 on at
    RE: Can I change the this format 0117(mmyyy) to convert to mm/dd/yyyy format for crm reports.

    Hi,

    You should be able to use similar expression in SSRS report. I guess you can leverage String expressions to achieve this:

    The Right, Len, Left, and InStr, Join functions can be used in string expression to achieve this.

    Below links will be useful:

    http://sql-bi-dev.blogspot.in/2010/09/ssrs-expressions.html

    http://www.venkateswarlu.co.in/msbi/ssrs/SSRS_Common_Functions__Text.aspx

    https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans