Set Date to dd/mm/yyyy

[abenitez77]

How can I set the date to dd/mm/yyyy for the entire app? I know you can set the server/desktop to the format date you want but in this case I cannot. I want to set the application to the format date of dd/mm/yyyy. Can this be done? There is a query that is taking a date from a text box and it is converting the data in the fly.

the text box has this value "between #25/03/2012# AND #13/05/2012#". This string is used in a query def and also passed to an existing query as well and the date is changed to mm/dd/yyyy

 

[PHV]

Use a non ambiguous format like this: #2012-04-01#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886