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
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.
DatePart("ww", Fields!createdonValue.Value)
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
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.
use the below function to convert strign to date time
=DateTime.Parse(Fields!DateTimeinStringFormat.Value)
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156