hi i would like to select in my database the latest date he updated his record.
in my database theres a column date_updates.
date_update Username(foreignkey)
08/10/2011 aaa
08/17/2011 aaa
08/24/2011 aaa
now i want to select his last date update..
select date_update will select them all, i want to select only the latest and compare it to my windows form if 7 days have passed and remind him to update again.
i want to do this after..
if ((date_update + DateTime.Now).Days > 7)
{messagebox.show("please update you profile")}