joshua_8
0
Newbie Poster
Recommended Answers
Jump to PostA lot of it depends on the data type for the field you are storing the date ( DATE, TIME, DATETIME, TIMESTAMP, or YEAR) in. You need to make the data you are searching against look like the data type.
Try this:
where table.date_field >= starting_date and <= CURDATE();
Or …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.