6
Answers

Date Check Using Database

Photo of Viral  Patel

Viral Patel

9y
772
1
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  

Answers (6)

0
Photo of Viral  Patel
NA 39 21.5k 9y
Date Check But Middle Date Not the proparlly work plz check
0
Photo of Viral  Patel
NA 39 21.5k 9y
Date Check But Middle Date Not the proparlly work plz check
0
Photo of Sumit Joshi
NA 1.8k 94.2k 9y
Hi Viral
 
You can use Between Column_Name1 And Column_Name2 
 
It solves your Problem 
0
Photo of Upendra Pratap Shahi
186 10.4k 2.1m 9y
SELECT * FROM Product_sales  WHERE From_date >= '2013-01-03' AND To_date <= '2013-01-09'
0
Photo of Viral  Patel
NA 39 21.5k 9y
1.servani1opendate 2.servani1closedate
0
Photo of Sumit Joshi
NA 1.8k 94.2k 9y
Hi Viral
 
Give database Field Names as well 
Next Recommended Forum