Date changes format

[scoe]

Hi

Hope someone can point me in the right direction, I am trying to put an if statement with dates in my form and strangely it worked once but after then it has changed the format to the american version and I don't seem to be able to get it to format back to dd/mm/yyyy.

[If #27/10/2013# > StartDate And #08/11/2013# < EndDate Then
Me.[No of Weeks] = Me.Text679 - 2]

Both [StartDate] and [EndDate] are formatted dd/mm/yyyy.

I would be grateful of ay help.

Many thanks

[RuralGuy]

Maybe these links will shed some light on the subject:
http://support.microsoft.com/kb/q130514/en-us
http://allenbrowne.com/ser-36.html

[scoe]

Thank you I will try these solutions.