>>>>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
>
>well, can you not have a little setup screen in your app, or a little shortcut menu where the user sets set date...

I'd rather just have the user set their preference in the Control Panel (or whatever it' called these days), and have my code deal with it.

J