>Hmm, I could have sworn there was a date part to datepart but I just looked it in my help and there is not. I also looked at DATEFORMAT( now(), 'Mm/dd/yyyy' ) as ddate but that value is returned as a char(). I do most of my work with a Sybase database that is tsql compatible but there are some differences. Not sure if dateformat() is available in MSSql.
>

No, don't remember this function. You can use convert to create varchar representation and you can get rid of time portion, but that's about it. In SQL Server 2008 you have two separate types: TIME and DATE. I don't know if it's easy to use them in VFP - I recall there were some problems...