Denise ----

When I have set a datetime (SQL Server, though) to date in a remote view and sent it to the backend, it has a 12:00:00 am time component.


>
>I sure hope to be there. Depends on what happens with the deadline for this project (which doesn't appear to be going *anywhere* :) ).
>
>If I use the dbsetprop to change the datetime type to a date, what effect will that have when I send the data back to the Access table? I would think that since it doesn't have just a date type that it would handle it okay, but you never know with Microsoft :).
>
>Thanks!
>
>>Hi Ed, Denise
>>
>>Denise (see you at the FUG in Jan?), an easy way to do this might be to use DBSETPROP() to change the DataType, for example:
>>
>>DBSETPROP("datetimefield","FIELD",DataType,"D")
>>
>>No mess, no fuss.
>>
>>
>>>>I've got this data that's coming from an Access database so the dates are in datetime format.
>>>>
>>>>I only want to show the date on my form. I found the time to date function and it works beautifully in the command window. I type in ?ttod(fieldname) and it gives me the date and everything's beautiful.
>>>>
>>>>However, I've got a textbox on the form where I need to do this same thing. I've tried putting the =ttod(fieldname) in the value property of the textbox but no luck. I've tried putting =ttod(fieldname) in the input mask and putting an "R" in the format, but still no luck. Where can I put this function so that I only see the date on my form?
>>>>
>>>>Thanks!
>>>
>>>if you use data-bound textbox then TTOD() should be in Textbox.ControlSource. If it's unbound then the place is Textbox.Refresh method: This.Value=TTOD(...