Access 2003 VBA Date format changes to American

[jimmy2]

Hi Guys,

I have a table which i have defined the input mask for a field as "dd/mm/yy" as i am entering data into this field the following happens

29 June 2011 = 29/06/11
30 June 2011 = 30/06/11
***01 July 2011 = 07/01/11****instead of 01/07/11

is there anything i am missing on why it displays 1 July differently. It misleads my calculations.

Would greatly appreciate correction/advise and guidance on this

Thanks in advance

 

[SydneyGeek]

Entering dates through the interface (eg, data entry), Access will use your regional settings.
Populating or using dates in VBA, Access will revert to US dates *regardless* of your regional settings. There are several possible workarounds for this. I usually convert the date to a number, using CLng (eg, CLng([MyDateField]) ) and that works because the serial number is unambiguous.

Denis

 

[jimmy2]

Thanks Sydney.

Im just going to try that now.