what is the query to look for latest date?

[choohean]

I try to write a query to insert the data by the conditionis the latest date but can't work...

Can someone give me a hand?

the code that I've write is like :

SQL ="UPDATE tracking SET c_name='"&c_name&"', c_email='"&c_email&"' WHERE equip_id='"&equip_id&"' AND date_in= max(date_in) "

 

[MrMystery]

You could try this.

UPDATE tracking SET c_name='"&c_name&"', c_email='"&c_email&"' WHERE equip_id='"&equip_id&"'
AND date_in =
(SELECT max(date_in) from tracking where equip_id = '"&equip_id&"')