By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

finding out system date settings on workstation

P: n/a
Good morning,

I am writing code to create a packing list number that is based on the
date entered from the workstation that the user is on. However, I do
not know how to determine the date settings and then act accordingly to
these date settings.

eg: By default, today's date is entered into txtDate. Then, the packing
list number is automatically generated as yyyymmssss where ssss is the
serial sequential number. I have written code which works fine on my
system, but I am working on Canada settings; guaranteed at least on
person in the office is working on US settings. How do I determine the
workstation's settings for the date formats through VBA?

TIA

Tim

Aug 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
tr*****@gmail.com wrote:
Good morning,

I am writing code to create a packing list number that is based on the
date entered from the workstation that the user is on. However, I do
not know how to determine the date settings and then act accordingly
to these date settings.

eg: By default, today's date is entered into txtDate. Then, the
packing list number is automatically generated as yyyymmssss where
ssss is the serial sequential number. I have written code which works
fine on my system, but I am working on Canada settings; guaranteed at
least on person in the office is working on US settings. How do I
determine the workstation's settings for the date formats through
VBA?

TIA

Tim
You don't need the settings of the workstation. Internally all dates are stored
exactly the same.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 17 '06 #2

P: n/a
Thanks Rick;

As soon as I finished writing the message, I found the solution. Sorry
for the waste of time (but thank you for the tip anyways)

Tim

Rick Brandt wrote:
tr*****@gmail.com wrote:
Good morning,

I am writing code to create a packing list number that is based on the
date entered from the workstation that the user is on. However, I do
not know how to determine the date settings and then act accordingly
to these date settings.

eg: By default, today's date is entered into txtDate. Then, the
packing list number is automatically generated as yyyymmssss where
ssss is the serial sequential number. I have written code which works
fine on my system, but I am working on Canada settings; guaranteed at
least on person in the office is working on US settings. How do I
determine the workstation's settings for the date formats through
VBA?

TIA

Tim

You don't need the settings of the workstation. Internally all dates are stored
exactly the same.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.