There will *always* be problems when you vector through a String in order to get to a date value. How do your Quebec centers enter the deposit date (use the August 5, 2009 date as an example)... that is, do they enter it *exactly* the same as the other cost centers (same digit order) or do they to it differently (and if so, how)?
--
Rick (MVP - Excel)
"JT" wrote in message ...
Sure.....Users enters the deposit date as mmddyy (080509). The macro
converts this to a string "8/5/09" and then converts it to a date (8/5/2009).
For the US cost centers this works great. Then the macor retrieves the
system date. I then use DateDiff to calculate the number of days between
each date.
The issue is with one cost center in Quebec where some of the machines have
French Canadian Regional settings on their PC.
The "8/5/09" string is converted into 2008-09-05. When this is compared to
the system date (2009-08-05) it is out of the 3 day range and they get an
error; when they shouldn't have.
I'm trying to get the 2 dates in sync so I can make an accurate comparison
Thanks for the help
--
JT
"Rick Rothstein" wrote:
I'm not sure exactly what problem you are encountering that prompted you to ask your question BUT, if your dates are stored as real Dates, the translations from system to system should be automatic. Remember, real dates are stored as floating point numbers which have no "format"... so the underlying value would be the same in the UK as it is in the US. Now, if your dates are stored as Text value... then there could be problems with conversions. Can you tell us a little more about your setup?
--
Rick (MVP - Excel)
"JT" wrote in message ...
Thanks..........What I want to do is get the date in whatever format the
user's regional settings are set to in a variable. Then I want to take that
result and convert it to a US date, so I can compare it to the date the user
has entered (in a US format).
--
JT
"Rick Rothstein" wrote:
If by "date variable" you really meant a variable Dim'med "As Date", then the answer to your question is no... sort of. Dates do not have format until they are displayed... to VB, they are just floating point numbers with the integer part representing the number of days past "date zero" (December 31, 1899) and the decimal part representing the fractional part of a 24-hour day (6:00am would be 6/24 which equals 0.25). When you display a date, VB uses your computer's Regional Settings to figure out how to show the date to you. You can over ride this pre-determined output using the Format function. You can also assign the output from the Format function to a String variable, and the text assigned to the variable will be in the form you specified in the Format function. So, the answer to your question kind of depends on what it is you want your code to actually do.
--
Rick (MVP - Excel)
"JT" wrote in message ...
Is it possible to convert a system date in dd/mm/yy format to the a date
variable in the mm/dd/yy format?
--
JT