AnsweredAssumed Answered

Switched Day and month values in find mode

Question asked by axammar on Mar 12, 2014

Title

Switched Day and month values in find mode

Post

     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?

Captura_de_pantalla_2014-03-12_a_la%28s%29_12.28.04.png

Outcomes