>Hi,
>
>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?
>
>TIA for any ideas! J

Doesn't set sysformats on work ?
Cetin