Skip to Content
0
Former Member
Dec 15, 2006 at 10:43 PM

Problem with DateTime parameters

26 Views

<p>My problem:</p><p>Crystal Reports 8.5 and MS SQL Server 2000. I create report with two parameters type DateTime - FromDate and ToDate. In Select Expert I define criteria &#39;Created&#39; (datetime field from SQL) is between {?FromDate} and {?ToDate} which is converted into formula in {?FromDate} to {?ToDate}. So far, so good.</p><p>When I now run this report with parameter values &#39;20.12.2005 00:00:00&#39; and &#39;22.12.2006 00:00:00&#39; I can see from SQL trace that query passed to SQL server is:</p><p>SELECT .... FROM ... WHERE Created Created >= "2005/12/20 00:00:00AM" AND R_Stoneridge_CountResult.Created < "2005/12/22 00:00:01PM"</p><p>Works as expexted. But now I found that on some client PCs using this report the query looks like</p><p>SELECT .... FROM ... WHERE Created Created >= "2005/12/20 00:00:00AM" AND R_Stoneridge_CountResult.Created < "2005/12/22 00:00:<strong>00</strong>PM"</p><p>and this is definitely wrong.</p><p>Can anybody suggest what can be wrong or what do I have to change in client PCs configuration</p><p>TIA</p>