Hi,
I have a situation to solve.
i have date stored in a table, not in a date format but in three different fields of type numeric. first is day, second is month, and third is year.
i want to compare dates in query.
Is is possible.
Thanks in advance.

I don't know how involved the task you have to accomplish may be, but you can build those 3 values into a string, and then use it...
...so I'm not sure if this will be the easiest method, nor do I know if a particular mysql/php function might be easier, but I created three separate values in one table, ran this select to a local variable, and then inserted the value to another table field with a date data-type, and it did fine.

What I would probably do is add another date-type field to the table, update the new field based on the concat() of the 3 values [to have a real date field] and then use the new date field in a query.

HTH.

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!