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.