In Fox 6, I am doing a SQL passthru command to get a table's structure from SQL Server 7, making the resulting cursor modifiable, and then setting several textboxes' ControlSource to the various fields. The date field in the cursor has the long date format that includes time. I would like the textbox to be in the date-only format (excluding the time). Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
When you don't want time for SQL Server
- Thread starter mcoupal
- Start date
- Thread starter
- #2
Mike Lewis
Programmer
Mcoupal,
I always do what RipRyness suggested. For the control source of the textbox, use TTOD() on the timedate field.
Mike
Mike Lewis
Edinburgh, Scotland
I always do what RipRyness suggested. For the control source of the textbox, use TTOD() on the timedate field.
Mike
Mike Lewis
Edinburgh, Scotland
- Status
Similar threads
- Poll
