GetAsText(date) always generates US format

[beezaman]

I am trying to get a database to work in multiple countries. Working with dates has proven to be troublesome. What I find is that if I use the GetAsText(date), the result is always US format, no matter what country system the database is running on and no matter whether I use Set Use System Formats [On] or not. Is the GetAsText function simply paying no attention to the local system format, i.e. is this a bug, and just using ghe format the DB was originally created in, or am I missing something?

[beezaman]

I am trying to get a database to work in multiple countries. Working with dates has proven to be troublesome. What I find is that if I use the GetAsText(date), the result is always US format, no matter what country system the database is running on and no matter whether I use Set Use System Formats [On] or not. Is the GetAsText function simply paying no attention to the local system format, i.e. is this a bug, and just using ghe format the DB was originally created in, or am I missing something?

[beezaman]

I am trying to get a database to work in multiple countries. Working with dates has proven to be troublesome. What I find is that if I use the GetAsText(date), the result is always US format, no matter what country system the database is running on and no matter whether I use Set Use System Formats [On] or not. Is the GetAsText function simply paying no attention to the local system format, i.e. is this a bug, and just using ghe format the DB was originally created in, or am I missing something?

[Ano Nimus]

I had sort of a similar problem: I used the function DayOfWeek(date). Here in Germany, on my German configured XP, today that would yield: 'Montag'. Then I changed the OS to speak and format all (dates, number separators, currency) in English. Still, new records created in my file would say that today is 'Montag', I expected 'Monday' of course.

I solved that by exporting the data, creating an empty clone and importing the data into that file. Then, the function correctly returned 'Monday'. Switching the OS back to German, however, revealed that the file now only gave the days in English.

It looks like that information is stored permanently in the file at the time of creation/cloning. Maybe the same goes for the date format?

I gave this info to FM Inc, who will hopefully do something about it in an updater or next version.

[Ano Nimus]

I had sort of a similar problem: I used the function DayOfWeek(date). Here in Germany, on my German configured XP, today that would yield: 'Montag'. Then I changed the OS to speak and format all (dates, number separators, currency) in English. Still, new records created in my file would say that today is 'Montag', I expected 'Monday' of course.

I solved that by exporting the data, creating an empty clone and importing the data into that file. Then, the function correctly returned 'Monday'. Switching the OS back to German, however, revealed that the file now only gave the days in English.

It looks like that information is stored permanently in the file at the time of creation/cloning. Maybe the same goes for the date format?

I gave this info to FM Inc, who will hopefully do something about it in an updater or next version.