Hello
Having an issue with the date in a UserForm Txt field, displaying US Date format.
For this example, I use these test dates: a) 2 Mar 2013 and b) 13 Mar 2013
Worksheet
Column8: LDATE
Format (UK date format): d/mm/yyyy
UserForm (purpose:to edit records on the ws)
Field: txtLDATE
Poulated from LDATE in ws.
The date is pulled from the ws to the userform with this code:
If I don't have the 'with' section of the code, the date comes into the UserForm in US date format, as so:
a) 3/2/2013
b) 3/13/2013
and I thought I had resolved that with the addition of the 'with' section of the code - however , no - it's only a half-solution:
This is the problem:
If I have the 'with' section of the code, only dates with a day from 13th to the 31st format as UK date.
Any date from the 1st the the 12th day, format as US date. As so:
a) 3 Feb 2013 (wrong)
b) 13 Mar 2013 (right)
If instead of the 'with' section of code, I have EITHER of the following lines - the result is just the same:
or
And it makes no difference what the dateFormat is on the ws - whether it's the exact same format
as in the code for the UserForm or not.
If anyone could help me reslove this, i would be most grateful! I have searched for solutions but can't seem to find anything.
Cheers
Annieb
Bookmarks