[AccessD] Date Comparison Problem

Smart solution, Rocky.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, March 30, 2006 8:34 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Date Comparison Problem

Dear List:

As I was writing this question a solution occurred to me.  But since I 
already spent all this time framing the question thought I'd post it 
anyway and add the answer to the end.

I have a routine which works when regional setting is set to English 
(United States) and fails when regional settings are set to English 
(United Kingdom) .  The difference is in a date compare.

The statement reads: "If datCurrentDate > Me.txtScheduleEndDate Then"

When set to United States datCurrentDate contains 12/02/2005 and 
Me.txtScheduleEndDate contains 07/30/2006 based on making a break point 
at that statement and hovering the mouse over the two variables.  So the 
test fails, as it should.

When regional setting is set to United Kindom datCurrentDate contains 
02/12/2005 and Me.txtScheduleEndDate contains 30/07/2006 .  This time 
the test passes which it should not.

Turns out that even though the text box shows 30/07/2006 it was not 
making the comparison correctly.  So I Dimmed another date 
datScheduleEndDate and changed the code to read:

        datScheduleEndDate = Me.txtScheduleEndDate
        If datCurrentDate > datScheduleEndDate Then


And now it works.

Solution in search of a problem.

Thanks (for making me think this through) and regards,

Rocky

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com