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