Switched Day and month values in find mode
Hi, I am trying to find all the records from a table created from the beggining to a specific date so I al setting a variable with "..." & ReceiptDate which the format is 23/03/2014. I have checked it in the debug window and it has the correct value.
the thing is then I insert this value in a date field in find mode but the day and month values are switched like ...03/23/2014 which is a date not valid since there is no 23rd month...
It seems like it switches from spanish format to american format...
Any ideas to fix this?