>>>Hi everybody,
>>>
>>>Is there a simple way to show date as
>>>
>>>mm/dd/yy regardless of set century setting?
>>>
>>>Thanks in advance.
>>
>>Where show it ?
>>
>>
>>* textbox.Century ON/OFF
>>
>>* plain text
>>? STUFF(DTOC(DATE()),7,2,"")
>>
>
>This does not work for Set date=italian and set century=off.
For any set date ...
I think that Naomi is able to finish the job ...
? STUFF(DTOC(DATE()),7,IIF(SET("Century")=="ON",2,0),"")
Happy new year Tore !