Rudy, sorry, forgot this bit, I have tried formating the date before I enter it into the database - i get the same problem. >> well, i certainly know the frustration, although in this case all you need >> to do is utilize the Format function