>>I'm working on a system for use in Thailand, where users mainly use date formats of dd/mm/yyyy. I want the user to determine the format from the system setting. I'm having a problem w/datetime values in a view. The view field is something like:
>>
>>IIF( lContact, TTOC( MadeOnDate ), SPACE( 22 ) ) AS cMadeOn
>>
>>The TTOC( MadeOnDate ) in the View is returning the date format in US format. I'm thinking that I have to write my own UDF to deal with this. Does anyone have any other ideas?
>
>
>Doesn't SET DATE BRITISH or DMY() help?

But if I want to let the user decide on the format (via system settings), wouldn't that force the format to British?

I want the user to decide how to see the dates, and have it mostly working, except for the view....J