How to Convert string date time to date format

(0) Share

Report

Posted on by NKC

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)

All responses (5)

Answers (0)

Suggested answer

Royal King 27,686 on at

Like (0)

Report

use the below function to convert strign to date time

=DateTime.Parse(Fields!DateTimeinStringFormat.Value)

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

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:

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.

Was this reply helpful? Yes No
NKC on at

Like (0)

Report

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

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nitesh Sharma on at

Like (0)

Report

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.

Was this reply helpful? Yes No