QDF / Calandar problem (1 Viewer)

LB79

Registered User.
Local time
Today, 16:55
Joined
Oct 26, 2007
Messages
505
Hi everyone…

I have a very odd problem with calendar control.
My function takes the date from calendar control (via a cbo box), and is used in a query def. This all works fine.
The odd thing is, if the date is between the 1st and 12th of the month, it swaps the day and the month. So 01/04/2010 becomes 04/01/2010. Any dates after the 12th of the month remain as they should.

Has anyone heard of this before?

Thanks
 

HiTechCoach

Well-known member
Local time
Today, 11:55
Joined
Mar 6, 2006
Messages
4,357
Yes. This is a common issue.

I use this:

Format([YourCBOcontrolName], "\#mm\/dd\/yyyy\#")
 

LB79

Registered User.
Local time
Today, 16:55
Joined
Oct 26, 2007
Messages
505
Thanks guys - will have a look...
 

Users who are viewing this thread

Top Bottom