Respected Friends,
 
                                I have sno(integer),name(varchar), event(varchar),planned (varchar ) ,conducted (varchar),email(varchar) in ADD_FACUlLTY  table. 
In planned field I am entering the future date that indicates when that event to be done in future and in Expected field when it was actually done will be uploaded.
 
conducted date as shown below.   
                         
 SNONAME  EVENTPLANNED  CONDUCTEDEMAIL 
 1 CHIRANJEEVI ADD ATTENDANCE 19-JULY-2015 19-JULY-2015 [email protected]
 2 VANDANA ADD MARKS 20  -JULY-2015            
 [email protected]
 3 TANUSHREE POST ATTENDANCE 20-JULY-2015
 [email protected]
 
when people forget to update their CONDUCTED date according to PLANNED date then we prepare forgot list at the end of the same day in gridview in c#
 
      forgot list shown below    for 20-july-2015      
 
SNONAME EVENTPLANNED CONDUCTEDEMAIL
2 VANDANA ADD MARKS 20 -JULY-2015
[email protected]
3 TANUSHREE POST ATTENDANCE 20-JULY-2015
 [email protected]
 
thanks in advance..