Marcia,

Thank you for the assistance.

"IIF( EMPTY( V_resident.dsortie ) , [] , Left(TTOC(V_resident.dsortie), 16))"

I have a last problem now.
I have 08/08/2004 8:34 and I would like to have 08/08/2004 08:34

How to have this result?



bernhart




>I want format a datetime in a grid but it i have problems.( VFP 8 Pack 1)
>
>What I generally do (if the grid is not a data entry grid < s > ) is set the controlSource for the column like this:
>
>

>( IIF( NOT EMPTY( MyALias.MyDateField ), MDY( MyAlias.MyDateField ), [] ) )
>