Help.. Date field on Master and detail blocks

Hi,
  I am creating one FORM with master and detail block relations. The   join condition likes "master.FIELD1 = detail.FILED2".

  Both FILED1 and FILED2 are in "MMDDYYHHMISS" format and the acture data in   database is "020196010000".

  When FORM was executed, the master FILED1 has data with "02-01-1996" and   no data was retrieved for detail block.

  After checking the SYSTEM.LAST_QUERY, I saw the query has bees executed   looks like this:
  "Select FILED2 from detail where to_date(FILED2, 'MM-DD-YYYY') =    to_date(MASTER.FIELD1, 'MM-DD-YYYY')"

  The query which the FORM executed does not include the hours, minutes and   seconds. When it converts MM-DD-YYYYY to database format, the hours become   12 and 00 for minutes and senonds. Therefore, the FORM converts   '02-01-1996' to "020196120000" and it won't match the detail block's data.

  I tried to modify the DEFAULT_WHERE clause in detail block and it does not   work. Any ideas???????
  Please e-mail me if you have any idea... Thank you..   my e-mail address is "kauj_at_lfs.loral.com" Received on Mon Jun 03 1996 - 00:00:00 CEST