QDF / Calandar problem (1 Viewer)

[LB79]

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]

Yes. This is a common issue.

I use this:

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

 

[HiTechCoach]

Here is more information on the subject:

International Dates in Access

 

[LB79]

Thanks guys - will have a look...