QDF / Calandar problem (1 Viewer)

LB79

Registered User
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

Registered User
Joined
Mar 6, 2006
Messages
4,264
Yes. This is a common issue.

I use this:

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

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom