you can try cdate function or the format function works good for me
sometimes.

format(strValue, "mm/dd/yyyy HH:MM AM/PM") then make sure you format
the other date string the same way.

Keith
www.kjtfs.com


---
Message posted from http://www.ExcelForum.com/