[AccessD] Date standardization

Coming in on this late...
I have had this issue too.
As I see it, VB per default is resolving dates in the format mm-dd-yyyy.
To free your expression from this resolving use:

Dim dtmdate AS Date
dtmDate=txtDate.Value

When dimensioning a variable to Date (or using thew function CDate on a constant) VB will consult the OS for language settings and resolve accordingly.

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
Sendt: 19. juni 2010 00:05
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Date standardization

And that's why I always display dates as dd mmm yyyy.

-- 
Stuart

On 18 Jun 2010 at 13:49, Heenan, Lambert wrote:

> That's why I simply never let users type a date. They always get a calendar form where it is patently obvious what date they are choosing.
> 
> Lambert 
> 

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