I have an HS400 table and a Oracle table
Crystal can see them both, but the dates are quite different
The Oracle database shows the date that the product was delivered, and always assumes midnight in it's date/time field
9/24/2002 12:00:00AM
The same delivery on the HS400 shows the date that the order was selected (always the prior calander day), as a number field
20020923
Will there be anyway of linking these two fields in Crystal, or do I have to build an automatic IBM query to build me a new report?
Thanks in advance
Rodger
Crystal can see them both, but the dates are quite different
The Oracle database shows the date that the product was delivered, and always assumes midnight in it's date/time field
9/24/2002 12:00:00AM
The same delivery on the HS400 shows the date that the order was selected (always the prior calander day), as a number field
20020923
Will there be anyway of linking these two fields in Crystal, or do I have to build an automatic IBM query to build me a new report?
Thanks in advance
Rodger