Date1 part record fields may for Chinese, the date format, most of the standard date, I want to find out date1 date, and near 3 days today, and the record of more than 3 days:
SQL="Select * from new_db where isdate (date1) and datediff (' d ', date1 date ()) & lt; '3' and status<> "
'completed'Use datediff will go wrong, use date1 & lt; Date () + 3 will not make a mistake, but find out record is a mess, is beyond the scope of the date of has also been found out