Date Time format in SSRS report in CRM 2011 online

Hi All,

Today I struggled a lot  while trying to format the date time field in SSRS report for CRM 2011 online version.

I tried many things to format the date like cdate(format(DateAdd(“d”, -61, now),”dd/MM/yyyy”)) , then =FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate) but in all the tries I was getting Expression error because of the month part in date value.

Then I found this solution and it worked well for me so sharing with you all.

=Format(Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(Fields!new_DatetimeFieldValue.Value ,Parameters!CRM_UserTimeZoneName.Value),”dd/MM/yyyy”)

Before implementing this expression make sure you add Parameters!CRM_UserTimeZoneName as a report parameter , add Microsoft.Crm.Reporting.RdlHelper, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 under Report Properties References and take the field as Fields!new_DatetimeFieldValue.Value instead of Fields!new_DatetimeField.Value.

Hope you will get rid of the date format issue.

Njoy!

Namaste 🙂

Megh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s