I am storing the date in a database using CDate(Now), but sometimes the date is stored as 8/3/01 11:27:16 AM and sometimes it is stored as 03/08/01 09:24:31, it is the latter I require being in the UK. Since all the PCs accessing my little app are on the Co network and all appear to be setup the same (Time/date is English GMT) can anyone tell me why sometimes the date is stored as mm/dd/yy, and others its dd/mm/yy. I thought this date came from the server which is just confusing me more now!!
What is the datatype of the field , where you are storing the date. Though as you have mentioned it seems to be Date/Time. Are you running application on the server or a copy of the application is installed on all the PC's?