Access 97 date function inconsistencies?
Posted on 2000-05-17
My system has been set up to use the time format dd/mm/yyyy in which the day precedes the month when displaying the date.
I have found that for some functions (such as day() and datevalue()) they would whatever format the user enters (eg. 17/5/2000 & 5/17/2000) and correctly displays the result (the day is 17th or 17/5/2000).
For other functions such as weekday(), it would not accept the system default but instead treat all date string as mm/dd/yyyy. So, if I entered weekdate(#8/1/2000#) it would return the wrong weekday because it doesn't intepret it as 8th January.
Is this a problem with Access 97 alone, or does it exist with all Office 97 products? Or is it a problem with Windows or VBA? Is there a patch for it, or other solutions? And does the same kind of problem exist with Office 2000 and/or Windows 2000?
FYI, my copy of Office 97 was bought in 1998 but I have since upgraded it to SR2. I am running Windows 98SE upgraded from an OEM (Dell) version.
Any wise and learned person out there who can shed some light on this subject - I'd be most appreciative. Thanks in advance!