QDF / Calandar problem

LB79

Registered User.
Local time
Today, 18:51
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
 
Yes. This is a common issue.

I use this:

Format([YourCBOcontrolName], "\#mm\/dd\/yyyy\#")
 
Thanks guys - will have a look...
 

Users who are viewing this thread

Back
Top Bottom