Inserting date into Access 2000

[ziwacky]

I have a field(FundDate). if left empty, I want to update record with a null value, otherwise the date entered. <br><br>I was told I need to type 3 ###'s so it will recognize it, but just don't work. <br><br>Update Table<br>&nbsp;&nbsp;Set<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FundRaiserDate = <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif #FundDate# is not ''&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;###FundDate###<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelse&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;null<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt; <br><br>What's wrong with it. Thanks.<br><br>

 

[achai]

try:<br><br>&lt;cfelse&gt;<br>'null'<br>&lt;/cfif&gt; <br><br>