CalendarLV

[Guest]

Hi, anyone used the calendarLV.mdb application in the uk yet? The date
selection when you view the calendar is interpreted in US format and I've
tried formatting to uk in the code and/or query which the calendar is based
on but can't get it working.
Would be really good if someone could help with this?
Thanks in advance.
Sue

 

[Douglas J Steele]

I'm not familiar with that particular application, but Access almost always
insists that dates be in mm/dd/yyyy format, or some unambiguous format such
as yyyy-mm-dd or dd mmm yyyy, regardless what you may have set as the Short
Date format in Regional Settings.

For more information about working with International Dates, see Allen
Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003 Access
Answers column for Pinnacle Publication's "Smart Access" newsletter. (The
column and accompanying database can be downloaded
for free at http://www.accessmvp.com/djsteele/SmartAccess.html)

 

[Guest]

Thanks Douglas, I've tried looking at this before but I just can't get it to
work. Was a long time ago though so I will re-read your suggestions and have
another go!

Thanks
Sue