AnsweredAssumed Answered

Switched Day and month values in find mode

Question asked by axammar on Mar 12, 2014


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?