Reply to thread

Message: [QUOTE="Jake, post: 183413, member: 67881"] Hi, Question, I was trying to get expiry date from my database, I already got those list display on my Listview. But when Im trying to update the year. Still showing on my list. sample Date today is 13-Apr-2019, i want to display those upcoming expiry +30 Days. but if I update it to 13-Apr-2020, still showing. My code i use. "Select * from TblEmployee where IDExpiry<=@IDExpiry" siemdi.Parameters.Add("@IDExpiry", OleDbType.Date).Value = DateTime.Today.AddDays(30) [/QUOTE]