Converting dates from a field with blank records

[NOTLguy]

I am using an update query to convert numerical dates ( eg. 34787 ) imported from Excel to a new field ( Access type date/time ). Not all the fileds have data so the query bombs out. How can I avoid that. Any help would be appreciated.

Old field name - DeathDate
New field name - DDate

Query: UPDATE Clients SET Clients.DDate = CDate([DeathDate]);



Thanks,
Bill

[slave138]

Add a WHERE statement:

UPDATE Clients SET Clients.DDate = CDate([DeathDate]) WHERE [DeathDate] Is Not Null;

(You might need the source info for [DeathDate] -- [TABLE].[DeathDate])

[NOTLguy]

Add a WHERE statement:

UPDATE Clients SET Clients.DDate = CDate([DeathDate]) WHERE [DeathDate] Is Not Null;

(You might need the source info for [DeathDate] -- [TABLE].[DeathDate])

Thank you for the quick reply. That worked. I really appreciate your help.

Regards,
Bill

[slave138]

My pleasure