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]

This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…