Haven't had to work with formatting dates a lot and now I need to. Soooo the docs say that to format time to have what's in the access db as 6:00:00 AM to simply 6:00 AM you need to use the following hh:mm tt. I tried that as formatDate(now(), "hh:mm tt") to test it but get a format type mismatch. Tried a couple of other ways as well. Anyone help out an old man with the right syntax? Looking at the FAQ's there is a custom format funtion to copy but all that code just to do this seems silly unless it's the only way.