VBA Date Format Issues US vs UK 1

[mordja]

Hi,

Im having some date issues. I have a database which several users use. Some have there regional date settings set to English, others to US. I get errors because on several forms I programmatically build filters and modify querydefs depending on the date. Is there a way in VBA that I could do something like

if dateSettings = US then
else

Thanks

Mordja

 

[RoyVidar]

Rather use the same format every time. Have a look at International Dates in Access and Return Dates in US #mm/dd/yyyy# format

Roy-Vidar

 

[mordja]

Thanks,

I always use the UK format. I got around the problem by using the dd-mmm-yy format when building my date strings.

Thanks

Mordja

 

[ProgramError]

Thanks for the link ROY-VADAR.
You have just saved me hours of programming time with the information provided on that site.
Once again thanks.


Program Error
Why is it, I still think in terms of spectrum BASIC!