I am not sure why VB makes everything such a pain. I have a fields which stores the date and time in the format required to store in MySQL database