connecting......

[3dthies]

I want to connect two databases via date field. The problem I have is that the first database has the date field as date and the second database has the date field as numeric.

How can I solve this problem?

 

[pgtek]

hi
u have to change the database field value name to date
in the table structure
cheers

pgtek

 

[3dthies]

i can't change the table structure in the database itself. there must be a workaround for the problem.

 

[pgtek]

hi
you could use a formula to change the data field to date in crystal but this will not permit you to link the tables do

have you tried to link the tables on an other field?
if you can then you will be able to create a formula to convert numeric to date
or
try a SQL statement to convert you field to date

cheers

pgtek

 

[PAULCALLAGHAN]

Is it possible to use the one datafile - where the date field is numeric - as a sub-report.

Set up a formula in this sub-report that converts this date field into date format.

Next, have this formula linked back to the other date field in the main report.