Resetting dates

2010-07-27 Thread Stephens, Larry V
I'm drawing a blank. Using CF8 with an Access database. I have a date field and test it at times for len() [i.e., if it's empty then...]. I set it with CreateODBCDate() but, at a later time, may wish to wipe out the date so it is empty again. Google isn't helping so before I test a bunch of

Re: Resetting dates

2010-07-27 Thread John M Bliss
SET mydatefield = NULL On Tue, Jul 27, 2010 at 10:41 AM, Stephens, Larry V steph...@indiana.eduwrote: I'm drawing a blank. Using CF8 with an Access database. I have a date field and test it at times for len() [i.e., if it's empty then...]. I set it with CreateODBCDate() but, at a later