>>>>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 !
A happy new year to you, too! :-)