Re: Between dates query

SELECT MONTH FROM TIME TWHERE to_char(:BLOCK1.VAL,'DD-MON-RR')  BETWEEN  T.DATE_1 AND T.DATE_2

if :BLOCK1.VAL is date field try
 SELECT MONTH FROM TIME TWHERE :BLOCK1.VAL BETWEEN  T.DATE_1 AND T.DATE_2

Mike Fellows wrote:

Hi there I have bben trying to create an SQL script used within a form to search for a value between two datesalong the lines of .... SELECT MONTH FROM TIME TWHERE :BLOCK1.VAL BETWEEN  T.DATE_1 AND T.DATE_2 This works fine, but when I try to carry out a TO_DATE function to ensure Y2K compliancy, I get an error.The script is as follows SELECT MONTH FROM TIME TWHERE :BLOCK1.VAL BETWEENTO_DATE('T.DATE_1','DD-MON-RR') AND TO_DATE('T.DATE_2','DD_MON_RR) Any ideas are greatly appreciated..TIA Mike