Dates US and UK

ronn2007@hotmail.co.uk

Guest

Posts: n/a

23rd Apr 2008

I have some VBA in a workbook that gets date data from SQL Server
2005.

Mystery: when this workbook is opened by some users they get the US
date (ie. 03/01/2008) and some users get the UK date (ie. 01/03/2008)
- the latter is correct (for 1st March 2008).

(1) Which setting on users' pc is causing this divergence?

AND (2) how can I force the date to come as '01/03/2008' regardless of
how the pc/Excel is setup on user pc?

Thanks!

« PopOver Help | How to set page orientation to "landscape" »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting dates to current dates to find out the evaluation date	Donica24	Microsoft Access Queries	1	26th Jan 2010 04:38 PM
Linking computer dates (time) to spreadsheet dates that have formu	bigisle	Microsoft Excel Worksheet Functions	2	3rd Jan 2010 08:05 PM
Copy/Paste 2009 dates into Tbale and they Show as 2008 Dates	ryguy7272	Microsoft Access	1	13th Nov 2008 02:13 AM
Toggle a range of Julian dates to Gregorian Dates and Back	=?Utf-8?B?UFNLZWxsaWdhbg==?=	Microsoft Excel Programming	4	8th May 2007 05:51 AM
Showing data between two dates in multiple subreports by enter two dates	Martijn	Microsoft Access Reports	0	26th Sep 2003 10:37 AM