query on date field

[bookor]

I need to query on a date field on a forms 4.5 form. This is NOT a sql query. In a sql select its easy enough to to_char the date and trim the time portion. However, I cant seem to find any way to do it on a form so I can do an oracle "form query." The query always fails to find the date even though I formatted the field to be 'mm/dd/yyyy' (to trim off the time portion of 09/09/9999 24:00:00). I tried to limit the query to the first x characters in the object properties on the form but it doesnt seem to work either. I tried every combination of trying to limit the query/field char to the first 10 characters but the query will not work.<br>
<br>
any suggestions would be appreciated...

 

[Shobin]

Hi Bookor,<br>
<br>
You should try TRUNC, TRUNC(date,'DD'); <br>
<br>
Good Luck<br>
<br>
Shobin