DATE QUERY on FORMS
207575Jul 30 2003 — edited Aug 7 2003Hi,
I need a desparate help on querying the date.
I have a very very simple block from a simple table that contains a date field. All I want to do is to be able to query based on date.
When I queried the database using following command,
SELECT * FROM equipment
WHERE to_char(date_created, 'mm/dd/yyyy') = '04/07/2003';
It retrieves some records.
In the form side, on the date_created field, for the format mask property, I entered 'mm/dd/yyyy'.
And when I put 04/07/2003 on that field and hit the query button, it retrieves NO record.
I tried to put the format mask property to be 'mm/dd/rrrr'
and it gives me the same result.
What should I do?
Thanks