Emanuel,
As I pointed out in my original question, TTOD(DateField) won't work.
This is because the textbox is bound to a remote view against a SQL Server smalldatime field.
Why would I want to set Dateformat to 4 (Italian)?
>This works for me
>
>
>* Put this code in the init event of your textbox
>
>SET DATE TO German
>SET CENTURY on
>
>dDate=DATETIME()
>This.Value=TTOD(dDate)
>This.DateFormat= 4
>
>
>>Bill,
>>
>>I may be doing something wrong here, but setting the textbox format to D does not seem to do much of anything.
>>
>>I have to set date = german, but that should not influence the format of the textbox, only the format of the date itself.
>>
>>>>I've been mucking about with input mask and format, all for nothing.
>>>>
>>>>And no, I can't just TTOD(somefield), so if there is a way to format the textbox to display only the date portion of a datetime field, would you please let me know?
>>>>
>>>>TIA
>>>
>>>Peter,
>>>
>>>I believe that you can set date to American, and set the format of the textbox to "D". That should give you the results you desire.
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)