COMPARING DATES

R

Román Valoria

I have a workbook with two sheets.

One of them has some data and the other has a ODBC connection to an Oracle
database.

I use the following array formula to get some values

= INDEX('Cementaciónes Ya Cargadas'!$D$2:$D$76,MATCH(1,('Cementaciónes Ya
Cargadas'!$A$2:$A$76='Cementación Secundaria'!$B8)*('Cementaciónes Ya
Cargadas'!$B$2:$B$76='Cementación Secundaria'!$E8)*('Cementaciónes Ya
Cargadas'!$C$2:$C$76='Cementación Secundaria'!$I8),0))

The problem resides in that one of the values to compare, specifically
('Cementaciónes Ya Cargadas'!$B$2:$B$76='Cementación Secundaria'!$E8) is a
date value. When I remove this column from the calculation I get a value, but
is the wrong one because I need the date to pick the correct one. If I
replace 'Cementación Secundaria'!$E8 with a hard-coded date between single
quotes, I get the correct answer.

I have tried to use Oracle functions in the Microsoft Query tool, with no
positive results. If I compare the values of the two matching cells using an
AND function, I also get a TRUE result.

What should I do to make the array formula work properlly?

Regards,
 
Top