>In Ms Sql Server, what is the value to put for empty date?
>
>In VFP, we put UPDATE stock SET receivedOn = {}
>
>But in Ms Sql, it seem did not work.
>
>TIA.

You need to set the date to NULL to get an empty date.

UPDATE stock SET receivedOn = NULL