Sir Babydum GBE
10-12-2007, 03:43 AM
Hi
I'm getting a problem when a workbook with a user form is used on some PCs.
txtDate is a form control, and it has a control source: =Validations!A2
That particular cell has =NOW() in it - so the idea is that whenever the form is submitted it adds the date and time to the record it creates.
The problem is that the format is being jumbled - and the date on the sumbitted record is wrong. So today's date is (using UK system of dd/mm/yy) 12/10/07, But on the records its coming out as Dec 10 - regardless of how it's formatted the serial date is wrong.
How do I fix so that when the fo submits a record it puts the correct date in?
I'm getting a problem when a workbook with a user form is used on some PCs.
txtDate is a form control, and it has a control source: =Validations!A2
That particular cell has =NOW() in it - so the idea is that whenever the form is submitted it adds the date and time to the record it creates.
The problem is that the format is being jumbled - and the date on the sumbitted record is wrong. So today's date is (using UK system of dd/mm/yy) 12/10/07, But on the records its coming out as Dec 10 - regardless of how it's formatted the serial date is wrong.
How do I fix so that when the fo submits a record it puts the correct date in?