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 CRM (Archived)

How to Convert string date time to date format

(0) ShareShare
ReportReport
Posted on by

Hi There

i am creating some fetch xml reports , the out put of the date values in string format how do i convert them into date format. Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Royal King Profile Picture
    27,686 on at

    use the below function to convert strign to date time

    =DateTime.Parse(Fields!DateTimeinStringFormat.Value)

  • Aileen Gusni Profile Picture
    44,524 on at

    Hi,

    You can either using code (expression in SSRS)

    =DateTime.Parse(Fields!DateTimeinStringFormat.Value)

    =Format(Fields!Time.Value, "dd/MM/yyyy hh:mm:ss tt" )

    =FormatDateTime(Fields!startdate.Value,DateFormat.GeneralDate)

    See this link: http://msdn.microsoft.com/en-us/library/dd255246.aspx

    or you can try use this one,
    for simple format (non dynamic condition), you can use this Textbox properties:

    ssrsstring2.png

    or custom

    Please see this blog for detailed format:

    http://dattatreysindol.com/2011/02/10/formatting-date-and-time-in-sql-server-reporting-services-ssrs-reports/

    Thank you.

  • NKC Profile Picture
    on at

    hi issue was solved i used following expressions

    =Format(Fields!scheduledstartValue.Value,"dd/MM/yyyy") -------date

    =Format(Fields!scheduledstartValue.Value,"ddd")________________day

    i want to calculate week number any idea how to calculate week numbers? Thanks

  • Royal King Profile Picture
    27,686 on at

    DatePart("ww", Fields!createdonValue.Value)

  • Nitesh Sharma Profile Picture
    on at

    Hi ...  I used

    =DateTime.Parse

    It is working fine on my machine inBIDS .. but when I upload rdl report to online CRM it gives error :

    The report server has RDLSandboxing enabled and the Field expression for the dataset 'DataSet1' contains a reference to a type, namespace, or member 'Parse' that is not allowed. Change the expression to include only allowed namespaces, types, and members.

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 CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
NeerajPawar Profile Picture

NeerajPawar 2

#2
jlattimer Profile Picture

jlattimer 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans