VBGamer

Put a format command around it eg format(yourdatevariable, "ddmmyyyy"). You could go through the date as a string and remove the '-'s but you may as well use VB's built in function. Hope this helps G