Hi all,

I have a database field (deliver_date) which stores date entered by user.
another two numeric fields(deliver_time_hh, and deliver_time_mm) which stores hh and mm in 24 hr format,

and newly added field (ActualDelivery) which stores date and time with NOW() function e.g. "05/31/2005 01:10:12 PM".

Now, problem is that i have to compate deliver_date,deliver_time_hh, and deliver_time_mm with ActualDelivery and get records in which
estimated is greater then actual. Since comparision has to be made in date and time.

In short, i need to convert deliver_date,deliver_time_hh, and deliver_time_mm to a single date whose formate is same as ActualDelivery and compare to ActualDelivery.

Any idea?
Thanks in advance.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Hi rupen

... post your code !

Steweb




Visit my web site !
www.steweb.net