Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) SSRS Parameters Date F...

SSRS Parameters Date Format Issue

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am fairly new to SSRS reporting for Dynamics CRM and i'm looking for help.

I have an issue with a report I am creating in Microsoft Sequel Server Reporting Services. I have a fetch xml created from Dynamics CRM (version 2016 update 1) which has been used in a dataset in SSRS. This has a date field in it called DOE. It is a calculated field that has a behaviour of Date Only. I have used this field to create two parameters, a start and end date. See screenshot below.

When i go to preview in SSRS it comes up with the error below.

I believe this error to be because of the date format. The DOE field seems to be coming through as MM/dd/yyyy rather than dd/MM/yyyy. I have set the report language to en-GB and i have tried numerous combinations of the FormatDateTime, CDate and Format functions on the parameter's but to no avail.

Can anyone help me fix this error? I'm going round and round in circles and not getting anywhere.

Thanks

Colin

*This post is locked for comments

All responses (1)

Answers (0)

David Jennaway 14,063 on at

Like (0)

Report

RE: SSRS Parameters Date Format Issue

With a FetchXml query, the dates should be in the format yyyy-MM-dd - e.g. 2017-06-30