Hi, guys! Are you okay?

See my query...

SELECT R.id_recomendacao, to_date(R.dt_fim_rec) - to_date(M.dt_inicio) AS PRAZO, to_date(CURRENT_DATE, 'DD/MM/YYYY') - to_date(R.dt_fim_rec) AS ATRASO

FROM TB_RECOMENDACAO R

INNER JOIN TB_MISSAO M ON (M.id_missao = R.fk_missao)

INNER JOIN TB_PROJETO P ON (P.id_projeto = M.fk_projeto)

WHERE P.fk_area = 222 AND R.sl_farol = 'vermelho'

Well, I need to make a stacked bar chart. Each "recomendação" has two date values, "PRAZO" and "ATRASO". This query works in SQL navigator, but in crystal, the second column (ATRASO) no. It returns "######".

I think it's because of "CURRENT_DATE". I tried to create a parameter with current date (to_date({?paramCurrentDate}, 'DD/MM/YYYY') - to_date(R.dt_fim_rec) AS ATRASO", but the problem continues...

I use SQL Navigator 5, but the db is Oracle. The query works on SQL Navigator very well. But it was not in crystal...

Now, I did it! I just removed 'DD/MM/YYYY'. This part was not necessary.

Thanks!!!