dear friends i want to filter data by date ... see the attach pictures, after using where clause i receicve 0 rows :(
Jump to Post
Since your check in date is actually a date+time you can't just go ahead and say
check_in = '3/11/2012'because this translates to '3/11/2012 00:00:000'
You should make sure that either your filter gets into account only the date part or filter for check_in between '3/11/2012' and '3/12/2012'
All 10 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.