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

RE: How to Convert string date time to date format

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

RE: How to Convert string date time to date format

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

RE: How to Convert string date time to date format

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

RE: How to Convert string date time to date format

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

Was this reply helpful? Yes No
Nitesh Sharma on at

Like (0)

Report

RE: How to Convert string date time to date format

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