The sysformat and date settings are data sessions dependant.
The view may be in another data session with different settings?
>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
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca