You can use the ttod() foxpro funciton or you could use the convert() function MSSQL.


>What's the best way to convert SQL Server datetime fields to VFP date fields when they've been accessed through SQL Pass-Through and control-sourced to VFP fields?
>
>Thanks,