Hi
Frédéric, I am having an issue with the datetime parameter function. Below is my query. I'm using SQL Business Intelligence Studio, SP 2. When I run the query it prompts me for the date parameters, but throws a sql exception after I enter them. I haven't been able to find the log files with the exception, but I suspect it's the date format, because if I remove the parameters, the query runs ok. I thought ERSDE handles the date format conversion? Do you have any ideas? Thanks.
<?xml version="1.0" encoding="utf-8" ?>
<root>
<list title="xxx" relativeSiteUrl="/xxx" tableName="results" useDisplayName="true">
<fields> </fields>
<query>
<Where>
<And>
<Geq>
<FieldRef Name = "Start_Date" />
<Value Type="DateTime"> @firstDate!</Value>
</Geq>
<Leq>
<FieldRef Name = "Start_Date" />
<Value Type="DateTime"> @lastDate!</Value>
</Leq>
</And>
</Where>
</query>
</list> </root>