Date Check Using Database

Question

Check Database Date : Database Fields : 1.servani1opendate 2.servani1closedate How to Check date in servani1opendate and servani1closedate using database Example: servani1opendate : 01/10/2015 and servani1closedate:10/10/2015 message pass Bokking and 02/10/2015  05/10/2015  07/10/2015 etc to servani1opendate and servani1closedate middle date can accept and other date not match Plz Solved This Quetion

Viral Patel · Answer

Date Check But Middle Date Not the proparlly work plz check

Viral Patel · Answer

Date Check But Middle Date Not the proparlly work plz check

Sumit Joshi · Answer

Hi Viral You can use Between Column_Name1 And Column_Name2 It solves your Problem

Upendra Pratap Shahi · Answer

SELECT * FROM Product_sales WHERE From_date >= '2013-01-03' AND To_date '2013-01-09'

Viral Patel · Answer

1.servani1opendate 2.servani1closedate

Sumit Joshi · Answer

Hi Viral Give database Field Names as well