>I'm pulling data from a database, and there are dates in this format:
>
>2011-08-05 03:52:00
>
>how can I drop the specific time at the end in so it's just the date? I'm not sure if I should do this in VFP or SQL Server.
In VFP 9:
cast(datetimeField as DATE)
If it's not broken, fix it until it is.
My Blog