Listed below is a sample string that deletes all records from a database where the date is less than 1/1/2002.  

Notice that you should also include the time string when deleting records from a database. 
 
DELETE FROM NAMEADDR where DATE2 < '01/01/2002 12:00:00AM' 
 
Listed below is a sample string that deletes all records from a database where the date is = 1/1/2002.  
 
Notice that you should also include the time string when deleting records from a database. IN this case, we get all records created between midnight and 11:59PM.
 
DELETE FROM NAMEADDR where DATE2 >= '01/01/2002 12:00:00AM'  and  DATE2 <= '01/01/2002 11:59:00PM'

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016