Look at TTOD(), TTOC()
>I have a DateTime Field in a table and I need to get the date portion and time portion for some comaprison, anyone know how to get portion from the dattime field?
>Thanks
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown