converting datetime to date for table joins 1

[wesw]

SQL Server 6.5
how does one go about joining two tables using a datetime field?
In SQL I would use the convert function and datepart to extract only the date for the join. How can I do this with Crystal. I changed the options to use only the date e.g. convert date time, but that doesn't seem to work.

thx

 

[dgillz]

You can convert a date/time field to a date as follows:

Date({DAte/Time Field})

However you cannot use a formula field to join to another table. you must use subreports to do this. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com