Pooja Chowdhury

Pooja Chowdhury

  • NA
  • 396
  • 37.3k

show data only which DB dates are greater than Todays date

Aug 10 2017 4:40 AM
Our db Table is
 
PolicyNo PolStartDate PolicyEndDate
567 10-08-2017 10-08-2017
9087 10-08-2017 10-08-2017
9087 10-08-2017 09-08-2017
9087 09-08-2017 09-08-2017
5643 09-08-2017 09-08-2019
45 09-08-2017 09-08-2022
56 10-08-2017 10-08-2017
123 01-01-2015 01-01-2021
 
** Here datatype of PolicyEndDate   is string .i didnot change it.
 
i  want to show only which PolicyEndDate is greater than and equals to  Today

Answers (5)