Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

Date Formats Access 2000

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Your own name as a domain name? Professional? gee..  
Author Message
morris

External


Since: Jan 10, 2005
Posts: 1



(Msg. 1) Posted: Mon Jan 10, 2005 4:35 pm
Post subject: Date Formats Access 2000
Archived from groups: microsoft>public>inetserver>asp>db;, others (more info?)
Why would the format of dates in an Access 2000 database change?

We have an intranet on a Small Business Server 2000 using Access 2000
and ASP. The Regional Settings on the server are UK English. Some days
the date information submitted to the database is in UK format, but on
other days it is US - even though the code writing to the db is the
same. Is it possible that the regional settings are overidden by something?

Morris

 >> Stay informed about: Date Formats Access 2000 
Back to top
Login to vote
kenremove

External


Since: Aug 23, 2003
Posts: 2901



(Msg. 2) Posted: Mon Jan 17, 2005 6:35 am
Post subject: Re: Date Formats Access 2000 [Login to view extended thread Info.]
Archived from groups: microsoft>public>inetserver>asp>db, others (more info?)
<a style='text-decoration: underline;' href="http://www.adopenstatic.com/dateswithaccess.asp" target="_blank">www.adopenstatic.com/dateswithaccess.asp</a>

Cheers
Ken

"Morris" <morris RemoveThis @nospam.cling> wrote in message
news:twBEd.100908$Z7.51210@fe2.news.blueyonder.co.uk...
 > Why would the format of dates in an Access 2000 database change?
 >
 > We have an intranet on a Small Business Server 2000 using Access 2000 and
 > ASP. The Regional Settings on the server are UK English. Some days the
 > date information submitted to the database is in UK format, but on other
 > days it is US - even though the code writing to the db is the same. Is it
 > possible that the regional settings are overidden by something?
 >
 > Morris<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Date Formats Access 2000 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS ASP Date Formats - I have the usual problem date formats, I want my ASP vbscript functions to always return dd/MM/yyyy british formats. I have a page with the following code <% response.write now() %> Sometimes it returns 11/6/2003 11:17:55 AM and Sometimes 06/...

Date and currency formats US instead of UK - Dear all, A simple "Response.Write Date()" in a plain .asp page is returning today's date in US format, e.g. "9/4/2003". I need it to come back in UK format, e.g. "4/9/2003". Also, "Response.Write "12345" s...

number and date formats - In a ASP application I have a FormatNumber function which supposal take the number format defined in control panel. But dont do it!!, By default the Win2k set 9.999,00 in numbers, i changed to 9,999.00 and then FormatNumber function takes the 9.999,0...

IIS logging formats do not gather hostname - I am using SUS at work and am trying to get IIS [SUS] to log the actual hostname. The IP addresses are DHCP so having the actual hostname would be very helpful to determine which machines are being patched. thanks, g

Custom Error Page file formats - Hi, What file formats can I use for my custom error pages. I would really like to make it that when an error page is displayed I could write an entry into my reports database telling me the details as to who they person was and what they were trying to...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]