SQL Server 7.0 date handling with Crystal 
Author Message
 SQL Server 7.0 date handling with Crystal

Here's my Stored Procedure:


and then I execute the SQL...

I don't seem to understand why Crystal Reports 8.0 and My stored procedure
don't get along too well.

Date handling seems to be a bit of an issue.  I've also tried changing the
parameters of the variables to nvarchar and tried to cast them as datetime
and smalldatetime strings yet they don't seem to work either.  I've also
tried passing on a string and then using both cast(field As
datetime|smalldatetime) and CONVERT.  Nothing seems to work!

Does anyone have any suggestions as to how I should declare my variables and
as to how I should place them into my SQL to work?

If I pass on text strings through a query such as SELECT * FROM ...  WHERE
table.datefield > 'mm/dd/yyyy' it works, but when I use a dynamic stored
procedures to use the same query I get an type mismatch error (or whatever
it's called).

I know this seems like a simple issue to most people who have had to handle
dates in SQL before, but I'm messed with this right now and could use the
help.  Thanks a bunch in advance for any help...  It'll be greatly

Tue, 29 Oct 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

2. Crystal Report Date Vrs Sql Server Date

3. Date problems in Access and SQL server 7.0

4. Dates, VB6 and SQL Server 7.0

5. Date problems in Access and SQL server 7.0

6. Problems inserting a date into SQL Server 7.0

7. Updating Dates in SQL-Server 7.0 Stored Proc thru VB.

8. Date problems in Access and SQL server 7.0

9. URGENT : CRPE32 (CR8), Subreport And Changing Server (with SQL Server 7.0)

10. Date Datatype in SQL server and Crystal Rpt

11. New Transact-SQL Debugger for Microsoft SQL Server 6.5/7.0

12. Problem on SQL-Update Statement with a Data-Control in VB 5 and SQL Server 7.0


Powered by phpBB® Forum Software