Forms: problem with parameter

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Sun, 25 Jul 1999 00:41:15 +0100
Message-ID: <379A4F1B.588B0D62@ieee.org>

Hello,

I am experiencing some trouble with Developer 2.1 When calling Reports 3.0 from Forms 5.0, I am passing the following parameter

sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN ''' || :DATE_BLOCK.START_PLAN || ''' AND ''' || :DATE_BLOCK.END_PLAN || ''' ORDER BY CALIBRACAO.PROXIMA'; the field uses date formated as YYYY/MM/DD

The line appears as DD-MM-YY, when year is greater than 1999 results are null.

Could anyone suggest me any workaround?

Thanks in advance

Received on Sat Jul 24 1999 - 18:41:15 CDT