set null as value in date

07-13-2006, 05:12 AM
Hi folks,

I'm using a MSDE 2000 database and i was wondering how you can delete a date recordvalue?

if i remember correctly you can't save a null value to the record. But what if the data i have entered wasn't for that field?

let me explain, I have a field BirthDate and a field PresentDate, what if i have by mistake filled in the present date in the birthdate but i want the birthdate to be empty? how can i save an empty date into a datefield so that the old date will be gone and no other date is in its place?

greets ghoti

07-13-2006, 06:45 AM
Not overly up on MSDE but...
Could try
Or look to see if the field in the database is set to allow nulls?

07-13-2006, 07:37 AM
Can you not Update the Date = NULL in Query Analyzer ?

update <tableName>
set BirthDate = NULL
where BirthDate = <value>


EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum