Thank, ...
I try
Bernhart
>>I tried to put a function in my View.(v_resident)
>>
><snip>>
>>
>>I have 2 problems.
>>
>>1) it is very slow
>>2) the index of the column is the controlsource ( cf Advisor 05/2004. Grid simplify )
>> Index On date caractere is different of Date.
>>
>>The format dates in my session form environment is "Short".(Windows parameters)
>>When I use "V_resident.dsortie" as ctrlsource (datetime) i use the short format.
>>When I use date shorts jj/mm/aa and Format HH:mm all is ok.
>>
>>How put by programming the format shorts and Format hours For my customers ?
>
>Bernhart,
>
>UDF's slow down queries considerably. See if you can use following expression in the view directly. It also is independent of any date or/and time settings.
SUBSTR(TTOC(ltDt,1),7,2) + "/" + ;
> SUBSTR(TTOC(ltDt,1),5,2) + "/" + ;
> RIGHT(SUBSTR(TTOC(ltDt,1),1,4), IIF(lCentury,4,2)) + " " + ;
> SUBSTR(TTOC(ltDt,1),9,2) + ":" + ;
> SUBSTR(TTOC(ltDt,1),11,2)
>