Mysql query with date conditions not working in server Pin

[ven753]

i want to show report based on date condition and show it in gridview. It is working in my local machine but not working in server after hosting. query is SELECT * FROM table WHERE DATE(colmn1) between 'startdate' and 'enddate' What could be the problem. If anybody knows please reply me. Thanks in advance

[Lost User]

ven753 wrote:

What could be the problem.

It could be the format of the date. Why is there a DATE-function on colmn1? Is it a varchar? Please don't crosspost. The question should not be in the .NET forum.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]