Doug,
Try TTOD(fieldname). That should convert your datetime field to a date only field.
>Is there a way to display SQL datetime values in VFP without displaying the time [only displaying the date]? Right now I am just making the field smaller so the user can't see the time to the right of the date.
>
>Thanks,
>Doug
Corey A. Rector
Ensite Inc.
Omaha, NE
** If you've got the time, we've got the beer. **