SQL statements - clearing date fields

[a3dvm]

Hi
I am trying to clear dates from 3 columns within a Paradox table using SQL Explorer.
The first went OK, as it only contained the character 'Y' (alpha field) and I used UPDATE {tablename}SET {field} = ''

When I try to this with the other two fields (formatted as date fields) I get 'type mistach in expression'.

Presume this is because date fields are strict on empty parameters?
Any ides on how I can clear these date fields please?

Den

 

[checkai]

you can set it to NULL

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[a3dvm]

Thank you Checkai, you are a STAR.
Worked like a dream.
(wished I asked 3 hours previously....)

Thanks again
Den

 

[checkai]

No prob...dates are always fun to work with...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."