Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Passing date parameter in SSRS report

I am trying to execute the following as an embedded query in an SSRS report, but cannot get the date parameters formatted correctly. Here is the query:

exec(
'Select Id, Service_Center_Area__r.Name, Service_Center_Name_Text__c, Owner.Name, CreatedDate, CaseNumber, ClosedDate, Timestamp__c, Priority,
Dispatch_Requester__r.Name, Task__c
From Case
WHERE Case.RecordType.DeveloperName = ''Sales_Service_Center''
And Service_Center_Area__r.Name = ?
And Day_Only(CreatedDate) >= ?
And Day_Only(CreatedDate) = 2018-05-01
And Day_Only(CreatedDate) ve done works. The @BeginDate value is 5/1/2018 12:00:00 AM
1 person has
this question
+1
Reply